Total should be the sum not a new calculation

[ThomasWeppler]

Hi power bi community,

I want to calculate the employees bonus based on what each employee have sold. So I have made a measure to do so. But when I look at the total in my Matrix it doesn't look at the total of the bonus but instead calculate it as if all the employees was a single person and calculate the bonus based on that. Is their any workaround or is this just a quirk of Power BI?

[ThomasWeppler]

Thanks for your responses. Here is a bit more inf o

Unfortunatly I cannot just add the meassure into a calculation becuase the salaey depends of the total number of invoices send out by the employee. I hope it makes more sense now when I have given some additional context.

[v-yanjiang-msft · Accepted solution]

Hi @ThomasWeppler ,

According to your description, I create a sample.

My solution is directly create a calculated column.

Column =
VAR _faktura =
    SUMX (
        FILTER (
            ALL ( 'Invoice' ),
            'Invoice'[UserName] = EARLIER ( 'Invoice'[UserName] )
        ),
        Invoice[Faktureret]
    )
VAR _basic = 20000
VAR _normal = _basic + ( _faktura - _basic ) * 0.35
RETURN
    IF (
        _basic > _faktura,
        _basic,
        IF ( _normal > _faktura * 0.5, _normal, _faktura * 0.5 )
    ) * 0.5

Get the correct result.

I attach the sample below for reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yanjiang-msft]

Hi @ThomasWeppler ,

If you mean the measure works fine in each row but incorrect in the total, you should modify the formula of the measure, add SUM or SUMX in the formula. Or a simpler way, create a calculated column.

Column=[Measure]

Then put the column in the visual, it will calculate correctly in the total.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Pragati11]

HI @ThomasWeppler ,

Please add more details to your query.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523