March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi all,
I am trying to SUM values based on distinct criteria in three other columns. The data looks something like this:
I need to sum the Points column based on distinct Titles, where Platform = B, and Label = blocker. I have come up with the DAX below:
It works correctly for system "A" and returns 7, but if I change the system to "B" it no longer works. It seems to only execute the CALCULATE piece and returns 2, when it should be 4. Why is it no longer working by simply changing the system to the other one? Is there a way to write this better? Thanks in advance!
Solved! Go to Solution.
Hi, @carly16
Try below measure
measure =
SUMX (
FILTER (
SUMMARIZE ( 'table', 'table'[Points], 'table'[system], 'table'[label] ),
'table'[system] = "B"
&& 'table'[label] = "Blocker"
),
'table'[points]
)
Best Regards,
Dangar
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @carly16
Try below measure
measure =
SUMX (
FILTER (
SUMMARIZE ( 'table', 'table'[Points], 'table'[system], 'table'[label] ),
'table'[system] = "B"
&& 'table'[label] = "Blocker"
),
'table'[points]
)
Best Regards,
Dangar
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
23 | |
16 | |
15 | |
7 | |
6 |
User | Count |
---|---|
33 | |
29 | |
16 | |
13 | |
12 |