Forum Discussion
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 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
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
1 Reply
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