Forum Discussion

danielboi's avatar
danielboi
Helper I
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
  • danielboi's avatar
    danielboi
    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
Super User
4 years ago

Hi! danielboi 

 

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.

 

  • danielboi's avatar
    danielboi
    Helper I
    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.