Dax % showing incorrectly

[vasathi]

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

[Fowmy]

@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 · Accepted solution]

This formula not working and still the same result. 

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

[vasathi]

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 

[selimovd]

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

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[vasathi]

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