topic Re: Total using ALL in a DAX in DAX Commands and Tips

Total using ALL in a DAX

coliveira03_ — Tue, 20 Jun 2023 15:51:13 GMT

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

Re: Total using ALL in a DAX

tamerj1 — Tue, 20 Jun 2023 16:30:05 GMT

Hi coliveira03_

Please try

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

Re: Total using ALL in a DAX

coliveira03_ — Tue, 20 Jun 2023 19:53:43 GMT

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