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.
Hi all... I have a simple table with account number and count field, I attempted to create simple measure. Not sure why it double when summing. Must be something simple, see below. Each row it double sum, the correct should be half per SUM Count measure.. total should be 15.
SUM Count - SUM(Table1[Count])
Hi @Tevon713 ,
What is [sum count] in table?
Try ISINSCOPE() and SUMX() function at total level.
Best Regards,
Jay
Thanks @v-jayw-msft. Sum Count is a measure that summing up the "Count" of Table 1.
Here's another look in matrix.
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 |
---|---|
110 | |
94 | |
80 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |