How to sum a collection of measures

[condolar]

Hello,

I have an empty table which I use to store a collection of measures, see image:

I wish to SUM all these measures together, which I know can be done by simply typing in each and every measure. However I will be adding several more measures to this, and removing some on other occaisons. I don't wish to have to amend my SUM calculation every single time, which will soon become extermely long and complicated.

I have isolated the measures I wish to sum in a table called 'Durations' and I was hoping there is a way to sum all the measures in this table in some easier way than to add every single one, one by one. Does anyone know how to acheive this?

Thank you

[v-rzhou-msft]

Hi @condolar ,

As far as I know, measures will return aggregated value in Power BI. If you want to sum measures, you need to add them in a new measure one by one. Power BI doesn't support us to sum measures in another way.

Best Regards,
Rico Zhou

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