Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.
why no item "Sum" in the red square?
Why I can't find "sum" in the value of Matrix tool? Should I make a new coulumn or new measure to produce Sum?
Thank you so much for your hints!!
How to find out sum in the red square? Please help me out !
Solved! Go to Solution.
Hi,
Have you checked that your data type is integer (whole number, decimal number or fixed decimal number)?
Here are the summarization options when my example data type is text:
After I changed the data type
I get the following options:
I hope this helps to solve your issue and if it does kindly accept this as a solution and consider giving it a thumbs up!
Proud to be a Super User!
It's data type problem. Thank you !!
Hi,
Have you checked that your data type is integer (whole number, decimal number or fixed decimal number)?
Here are the summarization options when my example data type is text:
After I changed the data type
I get the following options:
I hope this helps to solve your issue and if it does kindly accept this as a solution and consider giving it a thumbs up!
Proud to be a Super User!
| User | Count |
|---|---|
| 13 | |
| 9 | |
| 8 | |
| 8 | |
| 7 |