Forum Discussion

Carliniiiii's avatar
Carliniiiii
Frequent Visitor
2 years ago
Solved

Count based on distinct other column

Hello Power BI community,   I want to count the categories in a table per distinct identifier once. I can't remove the duplicates as they contain different data in other columns.    Identifier...
  • qqqqqwwwweeerrr's avatar
    qqqqqwwwweeerrr
    2 years ago

    Hi   Carliniiiii 

    If my understanding is correct you want distinct count of identifier for a given category?

     

    it can be direclty also in power in pie chart check below image

    is identifier in value and take distinct count or you can create measure:

    UniqueCategoryCount =
    CALCULATE(
        DISTINCTCOUNT('Table'[Identifier ]),
        ALLEXCEPT('Table', 'Table'[Category])
    )

     

    Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
    Check for more intersing solution here: www.youtube.com/@Howtosolveprobem

    Regards

qqqqqwwwweeerrr's avatar
qqqqqwwwweeerrr
Icon for Solution Sage rankSolution Sage
2 years ago

Hi   Carliniiiii 

If my understanding is correct you want distinct count of identifier for a given category?

 

it can be direclty also in power in pie chart check below image

is identifier in value and take distinct count or you can create measure:

UniqueCategoryCount =
CALCULATE(
    DISTINCTCOUNT('Table'[Identifier ]),
    ALLEXCEPT('Table', 'Table'[Category])
)

 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: www.youtube.com/@Howtosolveprobem

Regards