Keep a measure from filtering another measure

[zachthefrank]

Hey everyone, apologies for no file but it's a complicated model w/ sensitive data that would take hours to turn into a shareable sample.

I'm trying to show turnover and current headcount within a leader hierarchy of my company. I only want current leaders to show on the x-axis, but I still want the terminations under previous leaders to be counted or else the turnover calculation is incorrect. I'm currently trying to filter the mangers on the X-Axis by saying their current headcount (a measure) must be greater than 0, but that causes some terminations to not be counted. Is there a way to prevent a filter based on a measure from passing to another measure? Alternatively is there a better way to filter the X-Axis w/o filtering the underlying data?

[v-tangjie-msft · Accepted solution]

Hi @zachthefrank ,

You can create a measure.

Flag = IF([current headcount measure]>0,1,0) 

Place [Flag=1] on the screening of the visual object.

Before:

After:

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

Best Regards,

Neeko Tang

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

[zachthefrank]

I think this will work, but I ended up going with a completely different solution. Thanks for your input!

[lbendlin]

use disconnected shadow copies of your data to feed your slicers and axes.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...