Hi,
I have a measure that contains a Divide Function like as bellow
DIVIDE (
[Selling Price],
[Cost to Produce]
,
0
)
I have a Boolean column in the fact table and i want to add the filter in that measure [Cost to Produce] , i did this update as bellow:
DIVIDE (
[Selling Price],
CALCULATE (
[Cost to Produce],
FILTER (
'Fact Sales',
'Fact Sales'[IS_VALID] = 0
)
),
0
)
When i run the report i have a wrong value ,
And Also i have another measure that use Filter in Divide (<numerator> and <denominator>) and return wrong value
DIVIDE (
CALCULATE (
[Operate income],
FILTER (
'Fact Sales',
'Fact Sales'[IS_VALID] = 0
)
),
CALCULATE (
[Revenue],
FILTER (
'Fact Sales',
'Fact Sales'[IS_VALID] = 0
)
),
0
)
i don't know if my expression is correct or not .
Thank for your help