Calculate sum of rows of a measure

[kkashiv]

I have a measure named 'Measure 2' uses another measure to give a table like this.

DAX of 'Measure 2' 

I would like to create a measure that calculates the sum of each row for each place in Buildings. However the names and number of columns is not known as that is a filter applied from another visualization.

The reason I'm trying to calculate the total is because i want to represent a sorted cluster chart, however just utilizing the existing measure as the sort axis gives vague visualizations.

I will use the new measure as a tooltip which will allow me to sort the axis according to the total.

How can I achieve this?

[kkashiv]

How should I share the PBI file? I am using a SSAS connection to load the data model which requires secondary authentication.

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.

[kkashiv]

I have created dummy data and PBIX that represents the data model.
kkashiv.pbix

[Ashish_Mathur]

Hi,

Write this measure and drag it to the tooltip.  Sort by this new measure

Total of all commodities = SUMX(VALUES(Commodity[Commodity]),[Measure_2])

Hope this helps.