Measure won't filter from slicer

[Geoff1984]

I made a measure that calculates Bad Reviews from a column. But when I select a value from the review score slicer, the measure won't filter accordingly. So you will see that there are 6 reviews and 7 Bad reviews. Bad reviews shouldn't exceed the reviews because it's part of the whole reviews.

[Anonymous · Accepted solution]

Hi @Geoff1984 

You can try the following measure

Bad news =
CALCULATE (
    COUNTROWS ( olist_order_reviews_dataset ),
    FILTER ( olist_order_reviews_dataset, [review_acore] < 3 )
)

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.