Dax measure issue

[Diportee97]

 

Hello guys,i created previous month percentage measures for this cards but the second and the third cards are showing outrageous percentages like -97% instead of 2,4,5-10% just like the first card which is a bit messy,what is the way out guys

You will need to access my file for you to understand better...

The link below is my attached pbix file

https://drive.google.com/file/d/1Mi74b1Ryrw_6vucvpBTxVcASLl_JFG_V/view?usp=drivesdk 

[quantumudit · Accepted solution]

Hello @Diportee97 

The numbers are incorrect because you have used Patient Visits instead of Wait Time and Average Satisfaction Score in the respective past month calculation measures.

Here is the screenshot showing what caused the numbers to be incorrect in the report.

I have corrected the the past months and attached the file with the accurate calculations.

Best Regards,
Udit

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudo 👍

🚀 Let's Connect: LinkedIn || YouTube || Medium || GitHub
✨ Visit My Linktree: LinkTree

Proud to be a Super User