cancel
Showing results for
Did you mean:
Highlighted
Helper I

## Reading negative results as positive

Hi,

I'm performing a series of calculations to generate a total result and seggregate the total result based on its values as negative, positive or neutral.

However, I come to realise that even though the calculations gave the correct values but the DAX expression is unable to classify the values correctly according to the conditions that i've prescribed.

To illustrate my point:

Total = [Savings A] + [Savings B] + [Savings C]

where [Savings A], [Savings B], [Savings C] are calculated measures on their own.

To classify the total value i've used the following DAX expression:

Outlook = IF([Total]>0,"Savings",IF([Total]=0, "Neutral", IF([Total]<0, "Risks")))

However, some (not all) of the negative results (<0) from [Total] has been classified as "Savings".

I'm not sure why DAX failed to recognise those calculated results as "Risks", appreciate if anyone can enlighten me on this.

Thank you.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Helper I

## Re: Reading negative results as positive

i finally found the issue... not sure if i'm able to explain clearly..

The measure that i was using were dependent on other measures (namely Savings A and B) which required dynamic What-If inputs. Thus, when the seggregation had to be evaluated on a row-by-row context, there isn't any default inputs to replace the What-if inputs. Hence, in a row context, the results cannot be evaluated effectively which makes it problematic when power BI had to classify the data according to the row condition that i've given.

 Address Total (as calculated column) Total (as calculated measure) Savings A Savings B Savings C 8 Baker Street Infinity 35 5 10 20 21 Darling Road Infinity 75 35 40 0
Highlighted
Helper I

## Re: Reading negative results as positive

i finally found the issue... not sure if i'm able to explain clearly..

The measure that i was using were dependent on other measures (namely Savings A and B) which required dynamic What-If inputs. Thus, when the seggregation had to be evaluated on a row-by-row context, there isn't any default inputs to replace the What-if inputs. Hence, in a row context, the results cannot be evaluated effectively which makes it problematic when power BI had to classify the data according to the row condition that i've given.

 Address Total (as calculated column) Total (as calculated measure) Savings A Savings B Savings C 8 Baker Street Infinity 35 5 10 20 21 Darling Road Infinity 75 35 40 0

Announcements

#### Power Platform Community Conference

Check out the on demand sessions that are available now!

#### Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

#### Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021