Dax Measure issue

[Diportee97]

  

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?

[Anonymous · Accepted solution]

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

[Diportee97]

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 

[Diportee97]

 Here is my expected results