Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a column saying C1 = CALCULATE(SUM(column1)). It shows 50 in one.
Then I add another column C2 = CALCULATE(COUNT(column1)). It shows 2 in the same previous row.
Then I add column C3 = C1 / C2. Then I receive 50 for the same row!
AVERAGE does not work either. Any thoughts?
Solved! Go to Solution.
Convert these Columns into Measures... M1, M2 and M3
Convert these Columns into Measures... M1, M2 and M3
Thank you! I guess that is because the difference between measure and column are still blurry to me.
User | Count |
---|---|
102 | |
91 | |
85 | |
77 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |