Sum of Measure values

[Albawani]

Hi,

Is there any easy way to have a total sum for the measured values at the bottom of the table?

[Anonymous]

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

[PaulDBrown]

Add a new meaure:

Total = [measure 1] + [measure 2] + [measure 3]…

[Albawani]

I did this but it's unprofessional 

[Anonymous]

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

[PaulDBrown]

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.

[bcdobbs]

I'd missed the fact they are separate measures and you're using show on rows?

In which case @PaulDBrown is correct.

[bcdobbs]

Have to say, a bit confused! Can you send a screen shot of your format pane?

[Albawani]

Here it;s:

[bcdobbs]

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?

[Fowmy]

@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.

[Albawani]

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 ?

[bcdobbs]

If you click into the visual options for the matrix. You should be able to turn subtotals and totals on. Surprised though it's not on by default.

[Albawani]

unfortunately, i couldn't find the total or subtotal !!

[bcdobbs]

Few questions.

Is it a matrix or a table?

Are you using the preview visual pane?

[Albawani]

it's Matrix visual😥