topic Re: Dax Measure issue in DAX Commands and Tips

Dax Measure issue

Diportee97 — Fri, 21 Feb 2025 06:45:53 GMT

Hello guys,

Recently i ran into a small issue with a power bi

Dashboard,the patient visits growth arrow measure isn’t showing value,it only returned percentage symbol only and not value with percentage,what could be the cause and solution?

Re: Dax Measure issue

Diportee97 — Fri, 21 Feb 2025 06:48:30 GMT

Here is my expected results

Re: Dax Measure issue

Diportee97 — Fri, 21 Feb 2025 06:50:16 GMT

This is the pbix file of the dashboard,please help me guys,i need a solution https://drive.google.com/file/d/1XUNfliNDJtR96SoQUfzB8VGHnL0KZZY4/view?usp=drivesdk

Re: Dax Measure issue

Anonymous — Mon, 24 Feb 2025 02:09:18 GMT

Hi Diportee97 ,

Try adding a new column 'Year Month Number' in the calendar table and modifying the measure 'Patient visit pm'.

Patient visit pm = VAR __max_year_month =MAX ( 'Calendar'[Year Month Number] ) VAR __result = CALCULATE ( [Patient Visits], 'Calendar'[Year Month Number] = __max_year_month - 1, REMOVEFILTERS('Calendar') ) RETURN __result

Output:

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data in the Power BI Forum