topic How to Count in DAx in DAX Commands and Tips

How to Count in DAx

Tadadada — Fri, 15 Nov 2024 00:10:51 GMT

I have a table with MonthNum and patients. I want to count patient per month using month number.

Thank you

FreemanZ — Fri, 15 Nov 2024 01:30:10 GMT

just plot a visual with monthnumber column and a measure like:

count = DISTINCTCOUNT(tablename[patient])

or?

Poojara_D12 — Fri, 15 Nov 2024 04:43:24 GMT

To count patients per month based on the MONTHNUM column, use this DAX formula:

Patient Count = COUNTROWS(FILTER(TableName, TableName[MonthNum] = SELECTEDVALUE(TableName[MonthNum])))

Replace TABLENAME with your actual table name.

This formula counts rows where the MONTHNUM matches the current month context in your visual, giving you a monthly patient count.

Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
YouTube: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS

divyed — Fri, 15 Nov 2024 05:52:35 GMT

You can create a measure for the same.

PatientsPerMonth =
CALCULATE(
COUNT('YourTable'[patients]),
ALLEXCEPT('YourTable', 'YourTable'[MonthNum])
)

I hope this helps.

Mark this as solution if this helps or give a thumbs up.

Cheers.

Tadadada — Fri, 15 Nov 2024 19:37:02 GMT

Poojara,
This solution is just what I needed. Thank you

Tadadada — Fri, 15 Nov 2024 19:37:45 GMT

divyed,

Thank you for your help