Forum Discussion

BartDekeyser's avatar
BartDekeyser
Frequent Visitor
3 years ago
Solved

SubTotals

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   ...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi BartDekeyser 

    please try 

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

  • BartDekeyser's avatar
    BartDekeyser
    3 years ago

    So Easy, thank you very much. 

BartDekeyser's avatar
BartDekeyser
Frequent Visitor
3 years ago

So Easy, thank you very much.