topic Re: HOW TO RETURN/CALCULATE ROWS/COUNT BASED ON INVERSE SLICERS in DAX Commands and Tips

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

smpowerbi — Thu, 26 Mar 2020 07:44:52 GMT

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

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

Greg_Deckler — Thu, 26 Mar 2020 13:18:16 GMT

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

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

Anonymous — Mon, 30 Mar 2020 04:52:48 GMT

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