topic Re: National Sum of commission not working when selecting 2 or more office countries in DAX Commands and Tips

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

arpit_dhawan — Fri, 21 Mar 2025 12:43:41 GMT

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:

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

johnt75 — Fri, 21 Mar 2025 16:15:09 GMT

Try

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

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

v-kathullac — Thu, 17 Apr 2025 15:55:48 GMT

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.

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

v-kathullac — Mon, 21 Apr 2025 15:36:29 GMT

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.

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

v-kathullac — Mon, 28 Apr 2025 16:56:26 GMT

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.