Forum Discussion

LLT1021's avatar
LLT1021
Icon for Helper I rankHelper I
3 years ago

Correct totals

Hi all,

I have a question about the computation of totals. In the example below, I would like to have the column 'Verlies' as 0.2+0.4=06, so ignoring every month of the year but only sum over the 'Verlies' of the different Keys.
Does anyone have a clue how to fix this?

 

Need Help
Tips and Tricks

1 Reply

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    3 years ago

    Hi LLT1021 ,

     

    Depending on how you have the model you can try the following:

    Total Verlies = SUMX(DISTINCT(Table[Verlies]),Table[Verlies])