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 we have only the lines that contains this description

 

however, I need the folder TOTAL value - I have done the following dax and solves half of the problem

 

it does give me the folder total by line, but the total is a completly bigger number

I know once i am using all, is ignoring the filter applied by the slicer, and for that reason

But i am looking for another solution

 

ps.: i have summerized a new table with folder number and product type description, and in this case works.

 

 

however I work with a huge dataset already, and doing this I am only making bigger

 

 

I have tried many different ways and nothing seems to work - any help or insights are really appreciated

 

Many Thanks

 

  • Hi coliveira03_ 

    Please try

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

2 Replies

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion

    Hi coliveira03_ 

    Please try

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

    • coliveira03_'s avatar
      coliveira03_
      Frequent Visitor

      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