Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |