Forum Discussion
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 ...
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.
Leasie_7 Really hard to troubleshoot unless you can provide some sample data so that I can mock it up. However, regarding the measure not having the right value when you collapse...
First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e
This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8
Number Corrective Action Level 2 Outcome 35739 Account Update Accounting Overturned - Error 35349 Account Update Accounting Overturned - Error 33849 Account Update Accounting Overturned - New Information 33849 Account Update Accounting Overturned - New Information 35230 Account Update Accounting Overturned - New Information 33824 Account Update Accounting Overturned - Error 34540 Account Update Claims Processing Overturned - New Information 35201 Account Update Local Pharmacy Overturned - New Information 35150 Account Update Order Processing Upheld 34977 Account Update Order Processing Upheld 34977 Account Update Accounting Upheld 35695 Account Update Order Processing Overturned - Error 35609 Account Update Order Processing Overturned - New Information 35386 Account Update Order Processing Overturned - New Information 35075 Account Update Order Processing Overturned - New Information 33921 Account Update Accounting Overturned - Error 34133 Account Update Order Processing Overturned - New Information 33849 Account Update Order Processing Overturned - New Information 35465 Account Update Order Processing Overturned - New Information 34560 Account Update Order Processing Overturned - Error 34476 Account Update Order Processing Overturned - New Information 34377 Account Update Order Processing Overturned - New Information 34679 Account Update Web Portal Upheld 34679 Account Update Web Portal Upheld 35746 Account Update Order Processing Overturned - New Information 34121 Account Update Accounting Overturned - New Information 35201 Account Update Plan Benefit Overturned - New Information 34537 Account Update Plan Benefit Overturned - New Information 34954 Account Update Order Processing Upheld 34612 Account Update Website/portals Upheld 35709 Account Update Prior Auth Overturned - New Information 34560 Account Update Prior Auth Overturned - Error 35265 Account Update Override Upheld 35263 Account Update Order Processing Upheld 35263 Account Update Order Processing Upheld 35263 Account Update Web Portal Upheld 34148 Account Update Prior Auth Overturned - New Information 34462 Account Update Eligibility Upheld 35739 Account Update Web Portal Overturned - Error 34355 Account Update Website/portals Overturned - New Information 35012 Outreach to Provider Order Processing Upheld 35808 Account Update Order Processing Upheld 34606 Outreach to Provider Order Processing Overturned - New Information 35661 Account Update Plan Benefit Upheld 33945 Account Update Eligibility Overturned - New Information 34068 Account Update Eligibility Overturned - Error 35043 Outreach to Provider Plan Benefit Overturned - New Information 35048 Account Update Order Processing Upheld 35011 Account Update Order Processing Upheld 34143 Outreach to Provider Prior Auth Overturned - New Information 35775 Account Update Order Processing Overturned - New Information 34824 Account Update Eligibility Upheld 34824 Account Update Order Processing Upheld 35651 Account Update Order Processing Overturned - New Information 34335 Outreach to Provider Claims Processing Upheld 34335 Outreach to Provider Order Processing Upheld 35795 Outreach to Provider Prior Auth Upheld 34538 Outreach to Provider Order Processing Overturned - New Information 34876 Account Update Order Processing Overturned - Error 34876 Account Update Order Processing Overturned - Error 35876 Outreach to Provider Prior Auth Upheld 34611 Outreach to Provider Prior Auth Overturned - New Information 35756 Outreach to Provider Prior Auth Upheld 35663 Outreach to Provider Prior Auth Upheld 35578 Outreach to Provider Prior Auth Upheld 34335 Outreach to Provider Web Portal Upheld 34293 Account Update Order Processing Upheld 35604 Outreach to Provider Claims Processing Overturned - New Information 35435 Outreach to Provider Local Pharmacy Upheld 35604 Outreach to Provider Local Pharmacy Overturned - New Information 34096 Outreach to Provider Prior Auth Overturned - New Information 34096 Outreach to Provider Prior Auth Overturned - New Information 35544 Outreach to Provider Prior Auth Overturned - New Information 35843 Outreach to Provider Order Processing Overturned - New Information 33828 Outreach to Provider Prior Auth Overturned - New Information 34862 Outreach to Provider Prior Auth Overturned - New Information 35043 Outreach to Provider Prior Auth Overturned - New Information 35757 Outreach to Provider Prior Auth Overturned - New Information 34528 Outreach to Provider Prior Auth Overturned - New Information 35142 Outreach to Provider Prior Auth Overturned - New Information 34129 Account Update Order Processing Overturned - Error 34365 Outreach to Provider Order Processing Overturned - New Information 34365 Outreach to Provider Order Processing Overturned - New Information 34129 Account Update Order Processing Overturned - Error 35481 Outreach to Provider Plan Benefit Overturned - New Information 33821 Outreach to Provider Prior Auth Overturned - New Information 33821 Outreach to Provider Prior Auth Overturned - New Information 34310 Outreach to Provider Prior Auth Overturned - New Information 34310 Outreach to Provider Prior Auth Overturned - New Information 35195 Outreach to Provider Prior Auth Overturned - New Information 34531 Outreach to Provider Order Processing Overturned - New Information 33819 Outreach to Provider Prior Auth Upheld 33997 Outreach to Provider Prior Auth Overturned - New Information 34047 Outreach to Provider Prior Auth Overturned - New Information 34262 Outreach to Provider Prior Auth Overturned - New Information 34531 Outreach to Provider Prior Auth Overturned - New Information 35646 Outreach to Provider Customer Service Overturned - Error 35590 Outreach to Provider Prior Auth Overturned - New Information 33911 Outreach to Provider Order Processing Overturned - New Information 35777 Outreach to Provider Order Processing Overturned - New Information 33982 Outreach to Provider Prior Auth Overturned - New Information 34247 Outreach to Provider Prior Auth Overturned - New Information 35378 Account Update Web Portal Upheld 34139 Outreach to Provider Appeals Overturned - New Information 33904 Account Update Order Processing Overturned - Error 34946 Outreach to Provider Order Processing Overturned - New Information 34972 Account Update Order Processing Upheld 34972 Account Update Programs Upheld 34645 Account Update Web Portal Upheld 35071 Account Update Order Processing Overturned - New Information 34040 Account Update Order Processing Overturned - New Information 35360 Account Update Outreach Overturned - New Information 35104 Outreach to Provider Order Processing Overturned - New Information 33898 Outreach to Provider Prior Auth Overturned - New Information 34993 Outreach to Provider Prior Auth Upheld 34155 Outreach to Provider Prior Auth Overturned - New Information 34245 Outreach to Provider Prior Auth Overturned - New Information 33864 Outreach to Provider Order Processing Overturned - New Information 34147 Outreach to Provider Prior Auth Overturned - New Information 35595 Account Update Prior Auth Overturned - New Information 34941 Account Update Website/portals Upheld 34129 Account Update Prior Auth Overturned - Error 34589 Outreach to Provider Prior Auth Overturned - New Information 35546 Outreach to Provider Prior Auth Overturned - New Information 35341 Outreach to Provider Plan Benefit Overturned - New Information 35141 Outreach to Provider Prior Auth Overturned - New Information 35141 Outreach to Provider Prior Auth Overturned - New Information 33944 Outreach to Provider Order Processing Overturned - New Information 33858 Outreach to Provider Prior Auth Overturned - New Information 33967 Outreach to Provider Prior Auth Overturned - New Information 34957 Account Update Eligibility Upheld 34027 Outreach to Provider Prior Auth Overturned - New Information 34289 Account Update Prior Auth Overturned - New Information 33835 Outreach to Provider Order Processing Overturned - New Information 34144 Account Update Order Processing Upheld 35441 Account Update Web Portal Overturned - New Information 34532 Account Update Web Portal Overturned - Error Greg_Deckler Sorry I did not know how to get sample data on this post. Below is my attempt from the above sample data and you can see on the right when I collapse it does not hold.
Leasie_7 No need to apologize, that is literally perfect. Copies and pastes into an Enter Data query just fine. Let me see what I can mock up.
Leasie_7 One question, what is the formula for "Total Resolved RCA" measure?
The main Total Resolved RCA measure is
Total Resolved RCA = COUNTA('RESOLVED'[Number])The measure that I would expect to work with allowing filtering on outcome still is:Total Resolved RCA (Ignore Level 2) = CALCULATE([Total Resolved RCA],all(RESOLVED[Level 2]))