Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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 | |
12 | |
8 | |
8 | |
6 |
User | Count |
---|---|
27 | |
19 | |
14 | |
11 | |
7 |