Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
Is there any easy way to have a total sum for the measured values at the bottom of the table?
Hi @Albawani ,
Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem with you. Thank you.
Best Regards
Add a new meaure:
Total = [measure 1] + [measure 2] + [measure 3]…
Proud to be a Super User!
Paul on Linkedin.
I did this but it's unprofessional
Hi @Albawani ,
How did you set your matrix visual? Could you please provide the setting of Fields pane just as below screenshot? And please provide some raw data from the involved fields on the matrix visual. Is it one or more measures that are applied to the Values option of matrix visual? If so, please also provide their formulas. It is better if you can provide a simplified pbix file(exclude sensitive data). Thank you.
Best Regards
If the values in the matrix are different measures, you need a new measure for the total of all measures. It's not "unprofessional "; it's how DAX works.
Proud to be a Super User!
Paul on Linkedin.
I'd missed the fact they are separate measures and you're using show on rows?
In which case @PaulDBrown is correct.
Here it;s:
Does your measure always return either a number or a blank? Can you send it's definition over.
With the matrix selected click on the paint roller icon and send a screen shot of what is then displayed.
lastly with the model selected if you click on modelling at top what format is displayed for it?
@Albawani
First, check if the column that you are placing as values is in number or currency format. Then, you can turn on the total as follows for matrix visual.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
I couldn't find where to check the value type ! is it normal with Matrix table ?!
since it;s a measure value, would you suggest casting the measure as currency format ?
unfortunately, i couldn't find the total or subtotal !!
it's Matrix visual😥
User | Count |
---|---|
88 | |
88 | |
74 | |
67 | |
58 |
User | Count |
---|---|
136 | |
110 | |
91 | |
84 | |
69 |