Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Measure with IF renders useless results

Hello everybody,   I am working on a model where I compare budget sales planning with actual sales.   The model looks like this (streamlined version)   In Fact Actual Sales I have measure...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Thank you Ankit. just around the time when you posted your suggestion I figured out that I had the order of my sumx and if formulas wrong. Before I put the sumx function into the then and else of the if statement. Actually needs to be the other way round.

AnkitKukreja's avatar
AnkitKukreja
Icon for Super User rankSuper User
4 years ago

Hi! Anonymous 

 

1) Create a function or custom column with condition, if Budget is 0, 'Yes', 'No'.
2) Then you can use your measure with filter condition only on where budget was 0.

 

I hope it helps. Please share some sample data with expected result so I can share the output.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thank you Ankit. just around the time when you posted your suggestion I figured out that I had the order of my sumx and if formulas wrong. Before I put the sumx function into the then and else of the if statement. Actually needs to be the other way round.