Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello Community I have a Issue with this datset
When create a table the total average is wrong
How I can do the correct calculate? Any idea?
Solved! Go to Solution.
9.25 is the average of that table with those filters. Are you looking for 18.5 there? or something else?
Hello Nick, Yes I'm looking for 18.5
try:
SUMX( VALUES( TABLE1[PRODUCT]), [AVERAGE] )
Thank You! Nick this works fine!
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |