cancel
Showing results for
Did you mean:
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

Regular Visitor

## Re: conditional divide

Thanks Nathan,

Here are the visuals

Thw incoreect result on Power BI

The formula used

I will work on sharingthe PBIX.

Thanks

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.

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.

New Contributor

## Re: conditional divide

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

Regular Visitor

## Re: conditional divide

the result

The definition used :

for denominator

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])

Regular Visitor

## Re: conditional divide

Hi Nathan,

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

Thanks again.