Forum Discussion

Tadadada's avatar
Tadadada
New Member
1 year ago
Solved

How to Count in DAx

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

Thank you

  • Poojara_D12's avatar
    Poojara_D12
    1 year ago

    Hi Tadadada 

    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

5 Replies

  • FreemanZ's avatar
    FreemanZ
    Icon for Super User rankSuper User
    1 year ago

    hi Tadadada ,

     

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

    count = DISTINCTCOUNT(tablename[patient])

     

    or?

  • Poojara_D12's avatar
    Poojara_D12
    Icon for Super User rankSuper User
    1 year ago

    Hi Tadadada 

    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's avatar
    divyed
    Icon for Super User rankSuper User
    1 year ago

    Helo Tadadada ,

     

    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's avatar
    Tadadada
    New Member
    1 year ago

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