HOW TO RETURN/CALCULATE ROWS/COUNT BASED ON INVERSE SLICERS

[smpowerbi]

HI ALL I HAVE THE REQUIREMENT TO CALCULATE PERCENTAGE BASED ON FILTERS CALLED PLAN 'YES', AND REMAINIG DATA CALLED PLAN 'NO' THE SCENARIO AND SAMPLE DATA PLACED IN THE FOLLOWING LINK. HELP ME TO SORT OUT THIS.

https://filebin.net/kywxo2d7hrfjeuxx

THANKS AND REGARDS

SENTHIL

[Anonymous · Accepted solution]

Hi @smpowerbi ,

Create a measure as below 

WeekFilter = Maxa(PlanTable[weekname])

Use this measure in a "Details" table visual in your report. 

This will return Blank for not macthing filtered values and 0 for matched values. Use Visual Level filter for the details to get the inverse selected data in table.

Thanks,

PraveenM

[Greg_Deckler]

https://community.powerbi.com/t5/Quick-Measures-Gallery/Inverse-Aggregator/m-p/342266#M91

https://community.powerbi.com/t5/Quick-Measures-Gallery/Inverse-Selector/m-p/648290#M325