ALL function clarification

[planc7]

Hy everyone,

I have this very simple table:

Spoiler

YEAR	BRAND	VALUE	DATA TYPE
2019	AA	172	ACT+FRC
2019	AA	188	BDG
2020	AA	131,5	ACT+FRC
2020	AA	189	BDG
2021	AA	167	BDG
2021	AA	197,5	ACT+FRC
2022	AA	204	BDG
2022	BB	2	ACT+FRC
2022	AA	206,5	ACT+FRC
2023	AA	226	ACT+FRC
2023	AA	244	BDG
2023	BB	2	BDG
2024	BB	2	BDG
2024	AA	184	ACT+FRC
2024	AA	226,5	BDG
2025	CC	347	BDG
2025	CC	223,5	BDG
2025	BB	2	BDG
2025	AA	199,5	ACT+FRC
2025	AA	224	BDG
2025	AA	230	BDG
2026	AA	209,5	BDG
2026	CC	325	BDG

What i need to do, is showing all the "BDG" values even if "ACT+FRC" value is filtered.

The formula that I'm using is really simple and it is the following:

CALCULATE( SUM('Table'[VALUE]), 'Table'[DATA TYPE] = "BDG", ALL('Table'[DATA TYPE]) )

But, even if I used the ALL function to ignore the filter on DATA TYPE the matrix shows only this value

(for example, nor values for CC neither for BB is shown). 

 

How does ALL function work if a filter context exist?

Thank you, it is driving me crazy.

 

[Anonymous]

Hi @planc7 ,

I recommend using this DAX formula and then disconnecting the slicer from the matrix visual directly.

CALCULATE(SUM('Table'[VALUE]),'Table'[DATA TYPE] = "BDG")

Best Regards,

Bof

[Bibiano_Geraldo · Accepted solution]

Hi @planc7 ,

This occurs because brands AA and BB have some rows with the Data Type equal to "ACT+FRC," which is why they appear in the results. On the other hand, brand CC has no rows with the Data Type "ACT+FRC," so it was excluded.

The ALL function is working correctly; when using ALL in DAX, it removes any filters applied to a specific column or table.

My question is, why are you filtering only "ACT+FRC" if you want to see both Data Types?

To learn more about the ALL function, click here