Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
VeljkoP98
Frequent Visitor

Distinct count by Group

BookStoryGenreCount Historical
Book 1Story1Horror0
Book 1Story2Romance0
Book 1Story3Romance0
Book 2Story4Historical3
Book 2Story5Historical3
Book 2Story6Historical3

 

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!

1 ACCEPTED SOLUTION
johnt75
Super User
Super User

Try

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

View solution in original post

1 REPLY 1
johnt75
Super User
Super User

Try

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

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

Top Solution Authors
Top Kudoed Authors