Solved: HOW TO RETURN/CALCULATE ROWS/COUNT BASED ON INVERS...

smpowerbi · ‎03-26-2020

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 · ‎03-29-2020

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

View solution in original post

Anonymous · ‎03-29-2020

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 · ‎03-26-2020

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

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...