Forum Discussion
Solved
Measure won't filter from slicer
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.
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.
1 Reply
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.