SubTotals

BartDekeyser — Mon, 22 May 2023 13:13:00 GMT

Hi ,

I have a matrix visual created using relationships and Lookup.

When i remove Child from this visual The Total * index recalculates as does the index and the total to sums

A becomes 310, index becomes 1.4 and the total becomes : 434, that isnt correct. How can i prevent that.

I want the total to become : 132

Extra Information : Parent is a lookupvalue based upon Child. (We have a classification table for these matters)

Total and Index are measures, since date_sut has to be the same, date_pub has to be the most recent, so i had to do some recalculations.

I have 3 tables :

1 with Child Values, 1 with index values and the third one is the classification table.

Is there a possibility to adjust the total * index based upon the values selected in the visual, rather then summing it.

Re: SubTotals

tamerj1 — Mon, 22 May 2023 14:09:06 GMT

please try

Index * Total =
SUMX ( VALUES ( 'Table'[Child] ), [Total] * [Index] )

BartDekeyser — Mon, 22 May 2023 14:18:42 GMT

So Easy, thank you very much.