Table with totals from visuals

[Erika16]

I built several tables, (visuals) in Power BI.  Now I need a 'Total table' . Is there a way I can create a new table that adds up my visuals totals rather than bulding the ''Total table' from the data?  It is a bit tricky to do it from the data as each visual has specific filters different one to the other. That's why I wonder if like in excel I could built a new table that adds up the totals I already have on the visuals.  For example; the 'Total table' would show:

Clients 431 + 98 = 529

Min     420 + 55 = 475

Many thanks for your answers! 😁

[Erika16]

Thanks for your anser! I have both measures and  colums.

The issue I have is that they are filtered differently for each visual and mutually exclusive for  creating a total measure. 

[Anonymous]

Hi @Erika16 ,

You can get the total value you want by creating a measure.

Are your values(For example, MAX and MIN.) in a table a measure or a column?

You can create the following measure to get your total.

Total=SUMX(ALLSELECTED('TABLE'), [Measure/Column])

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.