National Sum of commission not working when selecting 2 or more office countries

[arpit_dhawan]

Hi All,

I have attached 3 screenshots for reference.

The thing is I want to calculate and show the national sum of commission against each office. There are 2 more parameters which are to be considered (Partner Tag and Intake) which are both Text type columns.

Now the thing is that the measure that I have created is working fine till the time that the selection has only one Office Country selected. As soon as I select one more country, the national sum aggregates the commission for both the countries and then displays that.

I want it to show the same number even if multiple countries are selected.

Measure: 

CALCULATE(

        SUM(tblStudentApplications[Commission]),

        REMOVEFILTERS(tblStudentApplications[Office Name]),

        ALLSELECTED(tblStudentApplications[Office Country],tblStudentApplications[Intake],tblStudentApplications[Partner Tag])

    )

Correct ones: 

The aggregation:

[v-kathullac]

Hi @arpit_dhawan  ,

we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?

If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

Chaithanya.

[v-kathullac]

Hi @arpit_dhawan  ,

we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?

If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

Chaithanya.

[v-kathullac]

Hi @arpit_dhawan  ,

we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?

If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

Chaithanya.

[johnt75]

Try

CALCULATE (
    SUM ( tblStudentApplications[Commission] ),
    REMOVEFILTERS ( tblStudentApplications[Office Name] ),
    SUMMARIZE (
        tblStudentApplications,
        tblStudentApplications[Office Country],
        tblStudentApplications[Intake],
        tblStudentApplications[Partner Tag]
    )
)