Forum Discussion

IF's avatar
IF
Icon for Post Prodigy rankPost Prodigy
5 years ago
Solved

Disctinct count of different values

Hi, I want to get distinctcount of the values from 6 different columns (C1,C2,C3,C4,C5, and C6). I exclude if the C2 is #. What I do is that I copy those and merge them in one column, named "All". ...
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    You could try using a measure instead like this one (don't create the concatenated column)

     

    NewMeasure =
    COUNTROWS (
        SUMMARIZE (
            FILTER ( Table, Table[C2] <> "#" ),
            Table[C1],
            Table[C2],
            Table[C3],
            Table[C4],
            Table[C5],
            Table[C6]
        )
    )

     

    Pat

     

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

You could try using a measure instead like this one (don't create the concatenated column)

 

NewMeasure =
COUNTROWS (
    SUMMARIZE (
        FILTER ( Table, Table[C2] <> "#" ),
        Table[C1],
        Table[C2],
        Table[C3],
        Table[C4],
        Table[C5],
        Table[C6]
    )
)

 

Pat