Filter Results using a Measure result

[btodres]

I am somewhat new to the whole DAX thing.

I have the following DAX Measure in my Power Pivot (which works fine): if('Ads - Current'[Ad Successes - (Adap - ACE)]>('Brightcove - Impressions'[Sum of Impressions])*1.10,"TRUE","FALSE").

I now want to take the result of the above measure and filter it such that only the "TRUE" results are shown in my pivot report. I cant figure it out, I tried using a filter with no success - PLEASE HELP!

thanks!

 

[ruve1k]

Have you tried applying a value filter to the field that you have on rows?
For example, say you have a field called Category as your row labels. Right-click the little drop-down on the Category header.
Then click Value Filters > Does Not Equal...

-- removed inline image ---

 

[powerpivotpro]

You can also try returning BLANK() from your IF:

IF([I]test[/I], [I]some value[/I], BLANK() )