Row totals not correct

[Anonymous]

Hello,

I'm stuck and cannot find the right way to solve my problem with the solutions in this forum. So forgive me if I ask the question that is already asked 100000 times...

The Case:

I have two collums : sales and fixed fee.

I created measures on those collums :  

€ Opbrengst kaartverkoop = SUM( DEAL[Opbrengst tickets (TM3)] )

and:

€ Garantiebedrag = SUM( DEAL[Garantie Bedrag (Deal)] )

Now I created a new measure:

partagering = [€ Opbrengst kaartverkoop] / 1.09

And finaly I made this:

Grondslag Partagering =

VAR DealWel = [€ Opbrengst kaartverkoop] > [€ Garantiebedrag]

RETURN

IF( DealWel,

[partagering] )

The result in the rows is now correct, but the total of the collumn shows the total of [partagering] instead of the result in the column...

Does anybody now how to solve this?

[Fowmy · Accepted solution]

@Anonymous 

To get the correct total, you need to use the integrator function SUMX, Replace TABLE[COLUMN] with the current table and column on against which you use these measures in the table visual.

Grondslag Partagering =
SUMX(
    VALUES('TABLE'[COLUMN]),

    VAR DealWel = [€ Opbrengst kaartverkoop] > [€ Garantiebedrag] RETURN
    IF( DealWel, [partagering] )
)

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[Anonymous]

Wow! This works! Thanks so much!!!