Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Good afternoon
I am having trouble showing the total of a measure in a table. I have tried sumx and having no joy. The total value in Gross bonus is showing £4924 where it should read £3603.10.
The Gorss bonus column is a measurement
Can anyone help please 🙏
Solved! Go to Solution.
SUMX() can be used to sum measure .I create a sample you can refer to it .
Original data :
Then create a measure to sum the value by name.
sum by name = CALCULATE(SUM('Table'[Value]),ALLEXCEPT('Table','Table'[Name]))
Return value :
At last ,create a column to sum the measure [sum by name]:
Column = SUMX('Table',[sum by name])
The final effect is as shown :
I have attached my pbix file ,you can refer to it .
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
SUMX() can be used to sum measure .I create a sample you can refer to it .
Original data :
Then create a measure to sum the value by name.
sum by name = CALCULATE(SUM('Table'[Value]),ALLEXCEPT('Table','Table'[Name]))
Return value :
At last ,create a column to sum the measure [sum by name]:
Column = SUMX('Table',[sum by name])
The final effect is as shown :
I have attached my pbix file ,you can refer to it .
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@ianboothman84 , this should not happen if it is a sum of a simple column. Usually happen with measure that uses row context
refer this
https://www.youtube.com/watch?v=ufHOOLdi_jk
or
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Hello @amitchandak the column is actually a measurement. I need the total of that measure
User | Count |
---|---|
88 | |
73 | |
69 | |
64 | |
56 |
User | Count |
---|---|
98 | |
92 | |
84 | |
74 | |
66 |