topic Re: Sum the values of a particular column based on multiple slicer selection in DAX Commands and Tips

Sum the values of a particular column based on multiple slicer selection

J0676s — Wed, 06 Mar 2024 18:49:39 GMT

Hi - I am trying to figure out how to calculate PQ column for it to give the sum of all selected quarters in the slicer. Right now it's giving values only for 1 quarter as I have used SELECTEDVALUE. I have tried using functions such as countx, ALLSELECTED, SUM but nothing seems to work

Re: Sum the values of a particular column based on multiple slicer selection

lbendlin — Wed, 06 Mar 2024 23:38:57 GMT

Read about VALUES(), SUMMARIZE, SUMMARIZECOLUMNS and ADDCOLUMNS. You need to collect all the selected values (not assuming it's only one) and then calculate your measure for each of them.

Re: Sum the values of a particular column based on multiple slicer selection

Anonymous — Tue, 12 Mar 2024 08:15:09 GMT

Hi J0676s ,

Based on your problems, I found a similar post to this one of yours on the forum, I think it addresses your question.

When you apply this metric you can get the results you need in Orders PQ # and PQ SUM when choosing a different slicer. Here is the Measure DAX code.

Orders PQ # = CALCULATE([PQ SUM],DATEADD('Calendar'[Date],-1,QUARTER))

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.