Solved: Distinct count by Group

VeljkoP98 · ‎08-17-2023

I would like to figure out how to have Additional column in which i would have for each book, number of Historical stories?

I don't know how to do count by GROUP.

Thanks for answers in advance!

johnt75 · ‎08-17-2023

Try

Count historical =
CALCULATE (
    COUNTROWS ( 'Table' ),
    ALLEXCEPT ( 'Table', 'Table'[Book] ),
    'Table'[Genre] = "Historical"
)

johnt75 · ‎08-17-2023

Try

Count historical =
CALCULATE (
    COUNTROWS ( 'Table' ),
    ALLEXCEPT ( 'Table', 'Table'[Book] ),
    'Table'[Genre] = "Historical"
)

Distinct count by Group