Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
33 | |
14 | |
12 | |
12 | |
9 |
User | Count |
---|---|
63 | |
22 | |
21 | |
17 | |
11 |