Forum Discussion
FU
3 years agoHelper IV
Counting Rows in a Matrix [unsolved 15/01]
Hi all, I am trying to create a (card or any other) visual which counts the number of distinct rows that are displayed in the matrix shown above. Please note I have the measure in th...
FU
3 years agoHelper IV
Greg_Deckler Greg_Deckler
You are correct in saying that the number of ''Attribute'' Rows may vary depending on the sliced ''date created'' filter.
The image below might be clearer than the one you have:
For those particular dates shown theres only 1 row that has change therefore I want a card to show the count of rows shown between those selected dates.
Lets assume I change another row - Risk ID PRID002 in my Excel table (today's date 14/01) and load it into the query - assuming my date ranges are set from min and max - I should be able to see 2 rows according to the image above. 1 change in PRID001 and 1 change in PRID002. Hope im making sense 🙂