Forum Discussion

vasathi's avatar
vasathi
Icon for Helper II rankHelper 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...
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.

selimovd's avatar
selimovd
Icon for Most Valuable Professional rankMost 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