Forum Discussion
Filtering on measure that excludes values
Natalie,
As I mentioned, filtering out Canada and USA by using FILTER will respect the filter context of the visual when it calculates the Booking Rate for you. However, when you use CALCULATE here, the calculate modifier is on the same column of the table that you're using in the visual and therefore it overwrites the filter coming from the table.
Let me know if that doesn't make sense. 😄
----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)
Change your approach to write the measure from the outside in. For ALL selected countries , sum up the bookings. Then sum up the sales (filtering out US and CA).
Finally compute your ratio . This will work both for the Totals and for the individual values.