Filter a Measure by the notselected value on filter
Filtering a measure by the values selected on a filter panel is easy, but I need to produce the contrary in other measure. So when I select a value on the filter, I expect that in one measure the left value in the filter are activated as a filter in the measure.
Filter Variable has only 4 values: Supplier1, Supplier 2, Supplier 3, Supplier 4
@tresesco the solution you provided seem almost working in my data, but not exactly. I may have gave a bad example so I have rewrite the post adding E () function solution you provided. The problem is that is not working as expected, I think the problem could come form how the data is structured, I hope the new example I have rewrited is more clear.