Forum Discussion

FU's avatar
FU
Icon for Helper IV rankHelper 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
Icon for Community Champion rankCommunity 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
      Icon for Community Champion rankCommunity 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
        Icon for Helper IV rankHelper 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 🙂