Forum Discussion

planc7's avatar
planc7
Icon for Helper I rankHelper I
1 year ago
Solved

ALL function clarification

Hy everyone, I have this very simple table: [ Spoiler ]   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 ...
Need Help
  • Bibiano_Geraldo's avatar
    Bibiano_Geraldo
    1 year ago

    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 

Bibiano_Geraldo's avatar
Bibiano_Geraldo
Icon for Super User rankSuper User
1 year ago

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