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 States of America" in the entire table.

Please let me know about how to use COUNTROWS function here to get the solution.

 

  • 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

3 Replies

  • 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