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 
    )

     

Russell93's avatar
Russell93
Frequent Visitor
3 years ago

Hello Rubayatyasmin, thanks so much for your reply but I'm afraid that edit is returning the same results (screenshot below). I did consider the percentage --> decimal relationship as DAX reads it, but I figured anything less than 0 as you suggested would work too:

 

  • 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.