Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, I am confused about the result of a DAX formula that is giving an unexpected result.
Notice how the totals for the 2 columns don't add up? This is a filtered table.
Scores |
129 |
99 |
246 |
213 |
243 |
Solved! Go to Solution.
In the total there is no filter on patient. Sumx is iterating over all 5 patients. While iterating it evaluates the second argument (MAX). Because there is no filter context it will evaluate every time the max of all patients (246). In the last step it will aggrate the five 246 in an sum (1260).
Thank you JW_van_Holst! I now get where this number comes from. That makes sense to me.
In the total there is no filter on patient. Sumx is iterating over all 5 patients. While iterating it evaluates the second argument (MAX). Because there is no filter context it will evaluate every time the max of all patients (246). In the last step it will aggrate the five 246 in an sum (1260).
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
20 | |
18 | |
15 | |
15 |
User | Count |
---|---|
46 | |
28 | |
25 | |
18 | |
17 |