SubTotals

[BartDekeyser]

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.

[tamerj1 · Accepted solution]

Hi @BartDekeyser 

please try 

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

[BartDekeyser · Accepted solution]

So Easy, thank you very much. 

[tamerj1 · Accepted solution]

Hi @BartDekeyser 

please try 

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