Forum Discussion

tjalleph's avatar
tjalleph
Frequent Visitor
6 years ago
Solved

Dynamic and categorized distinct counting

Hi all,   I'm fairly new to Power BI and trying to do something that could be called dynamic and categorized distinct couting.    A simplified sample of my data would like this: ID Category ...
Need Help
  • sturlaws's avatar
    sturlaws
    6 years ago

    Hi tjalleph ,

     

    you can write your measures like this:

    m0 =
COUNTROWS (
    FILTER (
        ADDCOLUMNS (
            VALUES ( 'Table'[ID] );
            "maxCodedAnswer"; CALCULATE ( MAX ( 'Table'[Coded_answer] ) )
        );
        [maxCodedAnswer] = 0
    )
)

     

    Cheers,
    Sturla

    If this post helps, then please consider Accepting it as the solution. Kudos are nice too.

tjalleph's avatar
tjalleph
Frequent Visitor
6 years ago
Works like magic! Thanks again.

To make sure i understand the concept: am I right when saying that we’re creating a temporary table with the distinct IDs and the maxCodedAnswer, that is subsequently filtered on the given maximum (in the example: 0)?

-Tjalle
sturlaws's avatar
sturlaws
Icon for Resident Rockstar rankResident Rockstar
6 years ago

Correct