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 ...
| 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.