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

[J0676s]

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

[Anonymous · Accepted solution]

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.

[lbendlin]

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.