Filter on IF statement DAX Measure

[Heather]

another option is a disconnected table showing Yes or No as the row values, a “SELECTEDVALUE” measure to return what is selected in the disconnected table, a final measure that returns a value of 1 if the row is equal to the SELECTEDVALUE return, then filter your table (as you have done in your sample) on the final measure to show only if the value is a 1.

This forum post demonstrates with a sample report:

Creating a slicer/filter with the calculated values from two columns

good morning @Vsb79 , as you did not provide a PBIX file (which is very useful even in cases like this) - I have made a few assumptions about your report: you followed best practices and are using measures for all of the values used in your report (not just pulling in the column) the two variance columns (Local Sales - National Sales, National Sales - International Sales) were created with measures and are not loaded into your data model. You are using a disconnected table for your filter stat…