Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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).
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
12 | |
11 | |
8 | |
7 |