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...
FU's avatar
FU
Helper IV
3 years ago

Greg_Deckler still unsolved! Counting on you 🙂

Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

FU Fairly certain this is what you are looking for, PBIX is attached below signature.

Measure = 
    VAR __Table = SUMMARIZE(FILTER('Project Risks Query-xxx',[Attribute]="Status"),[Risk ID],[Date created],"__Value",MIN([Value]))
    VAR __Table1 =
        ADDCOLUMNS(
            __Table,
            "__DistinctCount", 
                    VAR __RiskID = [Risk ID]
                    VAR __Result = COUNTROWS(DISTINCT(SELECTCOLUMNS(FILTER(__Table,[Risk ID] = __RiskID),"__Value",[__Value])))
                RETURN
                    __Result
        )
    VAR __Result = COUNTROWS(DISTINCT(SELECTCOLUMNS(FILTER(__Table1,[__DistinctCount]>1),"__RiskID",[Risk ID])))
RETURN
    __Result