Forum Discussion

vasathi's avatar
vasathi
Helper II
5 years ago
Solved

Dax % showing incorrectly

Team,

 

I have a problem to calculating the % for CY vs LY.

 

I Used following.

 

But my result is showing wrong like 


i dont' know how to fix.  Great thanks to Someone will help me to fix this output


Regards

 

Need Help
  • vasathi's avatar
    vasathi
    5 years ago

    This formula not working and still the same result. 

     

    Anyway i have fixed as work-arround with round function and got resolved.

5 Replies

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    5 years ago

    Hey vasathi ,

     

    can you in the same table put [ActualYTD] and [ActualSPLY].

    The division should not be the problem, but I guess one of the two measures is returning a result you don't expect.

     

    Also in your table I don't know which of the 4 columns is your measure as you don't tell us the name and don't show the header. I can only guess the percentage formatted, but I don't know.

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     
    • vasathi's avatar
      vasathi
      Helper II
      5 years ago

      Dear Selimovd

       

      Exactly the measure I am calculated to find growth %.

       

      I am not hiding anything in the first 4 lines.

       

      I have managed with following

       

      VAR = Round (ActualYTD,2)

      VAR = Round (ActualSPLY,2)

       

      And it's working as expected.

       

      Thanks for your suggestions

  • Fowmy's avatar
    Fowmy
    Super User
    5 years ago

    vasathi 

    Can you change the Divide function as follows and try?

    VAR _Grate = DIVIDE ( _TYamt - _lYamt , _lYamt )  

    If this doesn't work, please provide some sample data and the expected results

     

     

    • vasathi's avatar
      vasathi
      Helper II
      5 years ago

      This formula not working and still the same result. 

       

      Anyway i have fixed as work-arround with round function and got resolved.

    • vasathi's avatar
      vasathi
      Helper II
      5 years ago

      Dear Fowmy

       

      Thanks for update. Some how I managed to return

       

      I modified like 

       

      VAR = Round (ActualYTD,2)

      VAR = Round (ActualSPLY,2)

       

      Then my results are came as expected.

      Thanks for your suggestions also and will try