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 - 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.
How can I change existing WAP column to a measure column?
When I tried to create a new measure with formula : WAP1 = DIVIDE([WAP Denominator],[WAP Numerator]); it does 0 as the result.
Anonymous - Need to see the definition and results of the WAP Numerator and WAP Denominator also.
please see enclosed:
the result
The definition used :
for denominator
Anonymous - I was really baffled, but then saw the DIVIDE - Numerator needs to be first:
DIVIDE([WAP Numerator], [WAP Denominator])
Hi Nathan,
Thanks a lot for the help. It totally works now.
Thanks again.