Wrestling with Filter Context and "Included" - ALL() not working as expected

[bvy]

We audit widgets every day and look for certain quality control "issues". I have a slicer on Audit Date, and a calculation meant to return the Total Number of Units Audited within that date range. The correct value is 413 for May 17 - June 2. 

However when I select a Quality Control Issue from the list, it changes my calculation. The calculation should NOT be affected by a selection on Issue, however it’s putting in an “Included” filter and then throwing out days where we didn’t audit a widget with that particular issue – see how 5/17, 5/20 and 5/23 dropped from the list when I select Dent? However 413 correctly remains in the table.

I need the calculation to return 413, even when Issues are selected from a slicer or table. I thought I addressed the with the ALL filter, but it ignores it.

Note: I need to alter the CALCULATION – NOT the INTERACTIONS. The calculation is used outside of visuals. 

Thank you.

[v-yiruan-msft]

Hi @bvy ，

The ALL function returns all the values of a table, or all the values of a  column, ignoring any applied filters. I checked your second screenshot and you have also applied a visual-level filter to card visual (Audit Date is on or after 5/17/2022 and Included is Dent). And what you applied in the calculation is ALL(Audits[Quality Control Issue]), which returns all values of field [Quality Control Issue] in table Audits, and there are no fields [Audit Date] and [Included], so all these two filters should be valid for card visual...

What's your final expected result? Do you want to show 413 on the card visual ignore all filters? Could you please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

[bvy]

@v-yiruan-msft  Thank you for taking a look. Please see attached. 

https://www.icloud.com/iclouddrive/0ffPOE4Dp7nz7Z6yIjOO83dRw#PBIQualityIssue

[v-yiruan-msft · Accepted solution]

Hi @bvy ,

I'm afraid that there is no proper method besides that change the interaction between the table visual and card visual.

Best Regards