Forum Discussion

amansin19's avatar
amansin19
Frequent Visitor
4 years ago
Solved

Confusion about DAX function to be used...

I am analyzing a dataset where I need to find the rows under a specific column for a particular value. Like here, in the screenshot given below I want to find number of rows for country = "United St...
  • Nathaniel_C's avatar
    Nathaniel_C
    4 years ago

    Hi amansin19 ,
    Please try this

    US # =
CALCULATE (
    COUNTROWS ( datatable ),
    FILTER ( datatable, datatable[country] = "United States of America" )
)


    Let me know if you have any questions.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
    Nathaniel

Nathaniel_C's avatar
Nathaniel_C
Icon for Community Champion rankCommunity Champion
4 years ago

Hi amansin19 ,
Please try this

US # =
CALCULATE (
    COUNTROWS ( datatable ),
    FILTER ( datatable, datatable[country] = "United States of America" )
)


Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel