Total using ALL in a DAX

[coliveira03_]

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

[tamerj1 · Accepted solution]

Hi @coliveira03_ 

Please try

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

[coliveira03_]

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