Getting SUMX total row as a SUM of the SUMX values.

[MarceloDF]

Hi, I have this data:

This is a Matrix. So in the rows I have 2 dim tables (suppliers and products), then I have Stock for each product with the total of the supplier.
Then I have the % of each product regarding the total stock.

Then I have a measure with a divide of total sales and total stocks. (like an average)

And in the last measure (the one that I want to resolve) is this:

Cow price of 1kg  =

SUMX (

VALUES ( dimSupplier[supplier]),

[Average Measure] * [Percentage]

)

I want to show in the total, the sum of this values. But, of course, I'm receiving 36.71 * 100%, that is 36.71.

Thanks.

[MarceloDF]

@amitchandak the columns are empty in the visuals but changing the measure from Suppliers to Products it works!

Thank you very much!

[amitchandak · Accepted solution]

@MarceloDF , what is a column in visual? If that supplier the above should work. If that product then you should use the product

Cow price of 1kg =
SUMX (
VALUES ( dimProduct[Product]),
[Average Measure] * [Percentage]
)