Forum Discussion
Counting Rows in a Matrix [unsolved 15/01]
FU I used your PBIX when I created that measure. So you can just copy and paste it into your PBIX. I'm not quite certain what you are going for. Your matrix has some filters on it, do you want those same filters included in your count or not?
So let me explain:
I have imported the table "project risks" from an excel file on those different days shown in the filter so that I could see the changes in my values over time.
1) want to select a range from the date slicer and see what rows have changed from each table.
2) I want to create a card which counts those rows.
E.g. If I select 22/12- 24/12 and I have 3 rows that have changes between those dates then I want a measure which counts those 3 rows and displayed in a card.
So ultimately a measure which dynamically counts the number of rows shown in the matrix when filtered by "date created"
FU OK, so that I am absolutely clear. You may or may not have more than 3 rows in the matrix is that correct? But, you only want to count the rows where the status has changed between any dates, right? Or, do you want to count only if the min and max dates status is different?