The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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:
User | Count |
---|---|
12 | |
9 | |
6 | |
6 | |
5 |
User | Count |
---|---|
24 | |
14 | |
14 | |
9 | |
7 |