Forum Discussion

Diportee97's avatar
Diportee97
Helper I
1 year ago
Solved

Dax Measure issues

 Recently i ran into a small issue while replicating your Hospital Dashboard,the patient visits growth arrow measure isn’t showing value,it only returned percentage symbol only and not va...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Diportee97 ,

     

    You can modify this measure.

    Patient visit pm = 
var _date=DATE(SELECTEDVALUE('Calendar'[Year]),SELECTEDVALUE('Calendar'[Monthnum]),1)
RETURN 
CALCULATE([Patient Visits],FILTER(ALL('Hospital ER'),YEAR([Date without time])=YEAR(EOMONTH(_date,-1)) && MONTH([Date without time])=MONTH(EOMONTH(_date,-1)) ))

    Then the result is as follows.

     

    Best Regards,

    Neeko Tang

    If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Diportee97 ,

 

You can modify this measure.

Patient visit pm = 
var _date=DATE(SELECTEDVALUE('Calendar'[Year]),SELECTEDVALUE('Calendar'[Monthnum]),1)
RETURN 
CALCULATE([Patient Visits],FILTER(ALL('Hospital ER'),YEAR([Date without time])=YEAR(EOMONTH(_date,-1)) && MONTH([Date without time])=MONTH(EOMONTH(_date,-1)) ))

Then the result is as follows.

 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.