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 is similiar to what the end result will look like; I would show top 3, but my issue is within "Outreach to Provider". Specifically my issue I have lies within the denominator that's used to calculate the percentages below.

For the screenshot below I am using this measure directly mentioned below to get the correct denominator for my % calculation which I don't want to use because it does not allow my end user to change the filter on "Outcome" if they desire. 

Total Resolved RCA (Ignore Level 2) for Overturned Only = CALCULATE([Total Resolved RCA],ALL(RESOLVED[Level 2]),KEEPFILTERS(RESOLVED[Outcome]<>"Upheld"))

 

I would have thought I could have used this measure with ALL just I have have for other visuals, but it appears to act strangely and I do not know why: Total Resolved RCA (Ignore Level 2) = CALCULATE([Total Resolved RCA],ALL(RESOLVED[Level 2]))

 

I figured the screen shots below better show the components, my issue is why is the last column; my desired measure, is not showing "54" for all rows when filters or Corrective Action is in the matrix?

 

With "Corrective Action" as a Row in matrix with filter on visual to only show “Outreach to Provider” why does the last column not all show 54?

 

Same thing happens when I leave Corrective Action as a row in matrix and remove Corrective Action filter on visual

 

When I removed Corrective Action from the Row Section, but leave the visual filter on the last column now shows 54 appropriately. This however does not work for my desired result I need to be able to leave "Corrective Action" as a row on the matrix and filter on the visual, but retain "54".

 

Please any help is appreciated!

Need Help

8 Replies

  • 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

       

       

      • Leasie_7's avatar
        Leasie_7
        Frequent Visitor
        3 years ago

        Greg_Deckler 

        Something else quirky is my original measure of:

        Total Resolved RCA (Ignore Level 2) = CALCULATE([Total Resolved RCA],all(RESOLVED[Level 2]))
         
        has no issue with getting the correct value until you collapse a corrective action 
        correct:

         

        incorrect after collapsing "Claim Adjustment/Reprocessed"

         

         

        I feel like there is just something goofy going on.