count total occurrences with filter by category

[dwhittaker1]

I would like to create a measure that calculates the total occurrence of "Book" for each item. For example, in the table below "Item A" would have a value of 3 because "book" appears three times with "Item A". "Item B" would have a value of 2 because book appears 2 times  with "item B"

Item	Segment	Site	Status
A	10	Bank	Book
A	100	School	Book
A	100	Kitchen	Book
A	1000	Park	Extend
B	20	House	Book
B	20	Store	Book
B	10	Mall	Extend
B	10	Store	Extend

[amustafa · Accepted solution]

The DAX measure would be to count Status = 'Book' 

Book Count = 
CALCULATE(
    COUNT('Table'[Status]),
    KEEPFILTERS(
        'Table'[Status] = "Book"
    )
)