Help counting rows based on multiple criteria

[Earl40]

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 column is "AB" and the date colum (which shows month and year e.g October 2023) is February 2024. I then want this number to display in my card as the value

Any help would be greatly apreciated

[shravanreddy133 · Accepted solution]

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