Forum Discussion

coliveira03_'s avatar
coliveira03_
Frequent Visitor
3 years ago
Solved

Total using ALL in a DAX

Hi there, In my data set, I have many folders and in each folder, many products inside e.g.:    I need to user a slicer using product type description field, and when doing so automatically...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi coliveira03_ 

    Please try

    Sales Total =
    SUMX (
    DISTINCT ( Folder[FolderNumber] ),
    CALCULATE ( SUM ( Folder[SellAmount] ), ALL ( Folder[ProductTypeDescription] ) )
    )

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi coliveira03_ 

Please try

Sales Total =
SUMX (
DISTINCT ( Folder[FolderNumber] ),
CALCULATE ( SUM ( Folder[SellAmount] ), ALL ( Folder[ProductTypeDescription] ) )
)

coliveira03_'s avatar
coliveira03_
Frequent Visitor
3 years ago

Thank you very much! it worked perfectly


I have done the same sintax before, but in a different order and it made all difference. 

I have no idea why, but i am glad it worked.

 

Thank you