topic Dax Measure issues in DAX Commands and Tips

Dax Measure issues

Diportee97 — Thu, 20 Feb 2025 19:02:20 GMT

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 value with percentage,what could lead to this error and what is the solution,thanks

Re: Dax Measure issues

quantumudit — Thu, 20 Feb 2025 19:26:38 GMT

Hi Diportee97

Could you please provide sample data that fully represents your issue or question in a usable format, rather than a screenshot? Ensure the dataset is anonymized and does not contain any sensitive or unrelated information.

Additionally, it would be very helpful if you could share the expected outcome based on the provided data - this can be in any format, including a screenshot. Having a clear reference for comparison will significantly improve the chances of getting the correct solution in the first response.

For best practices, you may find the following links useful:

It seems like Patient Visit Growth returns blank. Need to see other measures and how they act.

Thanks,

Udit

Re: Dax Measure issues

Diportee97 — Thu, 20 Feb 2025 20:02:00 GMT

Thank you for your concern https://drive.google.com/file/d/1XUNfliNDJtR96SoQUfzB8VGHnL0KZZY4/view?usp=drivesdk

Thats the pbix file for more clarification

Re: Dax Measure issues

Diportee97 — Thu, 20 Feb 2025 20:07:34 GMT

The expected outcome is that green arrow for Previous Year or Previous Month

Re: Dax Measure issues

Anonymous — Fri, 21 Feb 2025 07:20:11 GMT

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.