Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Given two measures A and B with table given below (Mini - Table). Measures A and B are shown below.
Why does measure A give me an answer of 8?
The answer 8 for measure A is confusing me as its not doing the average like i'm expecting.
I understand that there is context transition happening for each shift inside the CALCULATE function. I am expecting the answer to be 4 for measure A since there are no filters applied in the table.
Can someone shed some light? Its driving me insane.
Measure A
Measure B
Solved! Go to Solution.
Figured out the answer to my own question.
Hi,
I am not sure how your datamodel looks like, but one of ways to check is, please check if one column is sorted by other column in MINI table.
I'm not sure how sorting is going to change the measure answer.
The table in the data model is as follow:
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 9 | |
| 9 | |
| 8 | |
| 6 | |
| 5 |
| User | Count |
|---|---|
| 23 | |
| 16 | |
| 15 | |
| 14 | |
| 8 |