Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Table with totals from visuals

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! 😁

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous ,

     

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.