Forum Discussion

Russell93's avatar
Russell93
Frequent Visitor
3 years ago
Solved

Conditional Measure Not Working the way I Imagined - any help greatly appreciated

So I have built a Sales Effciency data model with visuals showing effciency ratios each month of the year.    I had a request to show which stores have shown effciency improvements month-over-month...
Need Help
  • rubayatyasmin's avatar
    rubayatyasmin
    3 years ago

    probably it is returning value as a whole number, not in decimal. try dividing with 100. see if that works.

     

    Eff MoM Conditional =
    IF (
    [Efficiency % Chg] / 100 < 0,
    1,
    0 
    )

     

rubayatyasmin's avatar
rubayatyasmin
Icon for Community Champion rankCommunity Champion
3 years ago

probably it is returning value as a whole number, not in decimal. try dividing with 100. see if that works.

 

Eff MoM Conditional =
IF (
[Efficiency % Chg] / 100 < 0,
1,
0 
)

 

Russell93's avatar
Russell93
Frequent Visitor
3 years ago

Thx again for your help, that's a good idea but I'm afraid it didn't change the output either

I also tried using parenthesis to isolate the /100 in terms of order of operations hoping that might work, but no changes:

I will keep researching a solution to this, I think I may have to tell DAX to calculate based on individual Store #'s somehow. Thanks for all of your help

  • rubayatyasmin's avatar
    rubayatyasmin
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Are you certain that MOM calculation is giving the right value?

     

    check the table relationship.