Forum Discussion

Earl40's avatar
Earl40
Helper I
2 years ago
Solved

Help counting rows based on multiple criteria

Im trying to create a measure to count the # of items based on  multiple criteria. In my table I want to count the items where system column is "OCI" and the type column is "Notification" and origina...
Need Help
  • shravanreddy133's avatar
    shravanreddy133
    2 years ago

    Hi,

     

    You can create a measure and display that measure in your card visual.

    ItemsCount = CALCULATE( COUNTROWS(your_table), your_table[system] = "OCI", your_table[type] = "Notification", your_table[origina] = "AB", FORMAT(your_table[date_column], "MMMM YYYY") = "February 2024" )

     

     

    Or Just Count(Item_id) and apply the multiple critirea in your filters tab. Filter just on the visual.

     

    Cheers

shravanreddy133's avatar
shravanreddy133
Helper I
2 years ago

Hi,

 

You can create a measure and display that measure in your card visual.

ItemsCount = CALCULATE( COUNTROWS(your_table), your_table[system] = "OCI", your_table[type] = "Notification", your_table[origina] = "AB", FORMAT(your_table[date_column], "MMMM YYYY") = "February 2024" )

 

 

Or Just Count(Item_id) and apply the multiple critirea in your filters tab. Filter just on the visual.

 

Cheers