The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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
Solved! Go to 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.
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.
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.
User | Count |
---|---|
28 | |
12 | |
8 | |
7 | |
5 |
User | Count |
---|---|
36 | |
14 | |
12 | |
7 | |
7 |