topic Filtering Whole report by a measure given a dimension & the filters in DAX Commands and Tips

Filtering Whole report by a measure given a dimension & the filters

JoseCarbonell — Thu, 13 Feb 2025 17:15:23 GMT

Dear all,

Mi question here is simple and hope you guys can help me.

I have a report with a measure representing income. The measure works perfectly but:

I have been asked to filter such report by the result of this measure per client (dim client) but the measure also changes taking into account the company we are filtering for (dim company) which makes the solution quite difficult given my experience.

Is there a way I can filter my whole report for such clients (say income lower than 5k) and that that filter changes dynamically given the company we are filtering for?

Thank you in advance,

Re: Filtering Whole report by a measure given a dimension & the filters

Greg_Deckler — Thu, 13 Feb 2025 18:55:02 GMT

JoseCarbonell I mean, you could build that into your measure I suppose by returning a 1 or a 0 based on the criteria. It would essentially be a complex selector. So, if company A the threshold is 5K but for company B the threshold is 3K, you just build that logic into the measure and have the measure return 1 or 0. Then you can just filter to either 1 or 0. But, you have to do that for each visual. https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/The-Complex-Selector/m-p/1116633#M534