Forum Discussion

Leasie_7's avatar
Leasie_7
Frequent Visitor
3 years ago

Measure with ALL

I am in need of some expert help. I am very confused as I have not had this problem arise yet, though still relatively new to Power BI. To me it seems to be quirky...? -- Thanks in advance! Below ...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

Leasie_7 Try:

Total Resolved RCA (Ignore Level 2) for Overturned Only = CALCULATE([Total Resolved RCA],ALLSELECTED('RESOLVED'),KEEPFILTERS(RESOLVED[Outcome]<>"Upheld"))
Leasie_7's avatar
Leasie_7
Frequent Visitor
3 years ago

Greg_Deckler 

 

I updated your measure to not have the outcome <> upheld because I want the user to be able to look at upheld if they would like. 

Total Resolved RCA (Ignore Level 2) = CALCULATE([Total Resolved RCA],ALLSELECTED(RESOLVED))

 

It works when only one corrective action is selected 

However, when I bring in another they get the total between the 2. How do I get "Outreach to Provider" to reflect 54 and "Account Update" to show 45 so I can use it as the denominator for the middle % column on each corrective action category?

 

I am confused as to why I cannot use "ALL" with Level 2 instead of "ALLSELECTED" for the whole table. Shouldn't it see the visual filter context and apply based on whichever outcomes are selected along with corrective action selected to show in the visual. Maybe I need to use a combination of things to keep corrective action row context, but allow filtering on the whole "Resolved" table as well??

 

Thanks again