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 

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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