cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
natelpeterson New Contributor
New Contributor

Re: conditional divide

@SH-VE - 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

 

SH-VE Regular Visitor
Regular Visitor

Re: conditional divide

Thanks Nathan, 

Here are the visuals

 

Capture.PNG

 

Thw incoreect result on Power BI

 

Capture 1.PNG

The formula used

Capture 2.PNG

 

I will work on sharingthe PBIX.

 

Thanks

natelpeterson New Contributor
New Contributor

Re: conditional divide

@SH-VE - 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.

SH-VE Regular Visitor
Regular Visitor

Re: conditional divide

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.Capture.PNG

 

natelpeterson New Contributor
New Contributor

Re: conditional divide

@SH-VE  - Need to see the definition and results of the WAP Numerator and WAP Denominator also.

SH-VE Regular Visitor
Regular Visitor

Re: conditional divide

please see enclosed:

Capture 2.PNGthe result

 

The definition used :Capture 1.PNG

 

 for denominatorCapture.PNG

 

 

natelpeterson New Contributor
New Contributor

Re: conditional divide

@SH-VE - I was really baffled, but then saw the DIVIDE - Numerator needs to be first:

DIVIDE([WAP Numerator], [WAP Denominator])

SH-VE Regular Visitor
Regular Visitor

Re: conditional divide

Hi Nathan,

 

Thanks a lot for the help. It totally works now.

 

Thanks again.