Forum Discussion

FU's avatar
FU
Helper IV
3 years ago

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...
Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

FU Without a sample of your data hard to be specific. But, essentially, recreate your table/matrix in a table VAR and then use COUNTROWS.

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    3 years ago

    FU Sure, that helps greatly.

    Measure = 
    VAR __Table = 
        ADDCOLUMNS(
            DISTINCT('Project Risks Query-xxx'[Risk ID]),
            "__DistinctCount", [DistinctCount]
        )
    VAR __Result = COUNTROWS(FILTER(__Table,[__DistinctCount] > 1 && [Risk ID] = "PRID001"))
RETURN
    __Result
    • FU's avatar
      FU
      Helper IV
      3 years ago

      Greg_Deckler 

      What can I do with this measure? Note that my table consists of many rows, I've currently got a measure in to show me the rows that have different values in the date column so essentially I'm tracking data changes over time of the exact same table.

       

      I want to create a card or something which counts the number of rows based on the date created slicer that's shown. 

       

      Would be helpful if you could show an example on the pbix file and send it over 🙂

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion
        3 years ago

        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?