Forum Discussion
conditional divide
Anonymous - It looks like you're creating WAP as a Calculated Column. It needs to be a Measure. Also, Numerator and Denominator need to be Measures.
Anonymous - The solution that v-frfei-msft provided looks like it should work for your requirement. One thing you could try is to split out the numerator and denominator into 2 additional measures for testing:
WAP Numerator =
CALCULATE (
SUM ( 'Master Pricing Data'[Sales] ),
FILTER ( 'Master Pricing Data', 'Master Pricing Data'[Priced/Unpriced] = "Priced" )
)
WAP Denominator =
CALCULATE (
SUM ( 'Master Pricing Data'[Quantity] ),
FILTER ( 'Master Pricing Data', 'Master Pricing Data'[Priced/Unpriced] = "Priced" )
)
It worked for those entries which have one priced and the other unpriced, like this one.
However , those which have more than one priced , its incorrect, beause its adding up individual WAP
In secind case WAP should 899. However , its adding up 1250 and 808 to give 2058 as the result.
Anonymous - That calculation should work, so we need to see the text of your calculation and a screenshot of the wrong result in a Power BI visual. You may need to let us take a look at your pbix - you can upload it to dropbox or onedrive. Of course, protect your data.
Cheers!
Nathan
Thanks Nathan,
Here are the visuals
Thw incoreect result on Power BI
The formula used
I will work on sharingthe PBIX.
Thanks
Anonymous - It looks like you're creating WAP as a Calculated Column. It needs to be a Measure. Also, Numerator and Denominator need to be Measures.