cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
IamTDR
Resolver III
Resolver III

Sum Column w/ Distinct Filters Help

Hello

 

I needed a bit of help suming a column by distinct filters.

 

Please see below image.

 

I would like to write a measure that totals number of students by territory and by program.  The number of students would change depending on Territory and by Program selected via my slicers.

 

So what I would like my Students column total to be is 7,780 (5,139 + 1,061 + 1,580).

 

Not having much luck using a calculated function.

 

Any ideas?

 

Thanks

 

Capture.PNG

1 ACCEPTED SOLUTION

I just tried this out and I am currently testing as it seems to work.

 

Measure = MAXX(DISTINCT(Table1[Country]),MAX(Table1[Weight]))
SumWeight = SUMX(DISTINCT(Table1[Country]),[Measure])

View solution in original post

3 REPLIES 3
rocky09
Solution Sage
Solution Sage

@IamTDR

can you please post some sample data (you can directly copy data from excel and paste here)

Not totally sure how to do this.  As this is from Power BI Desktop

I just tried this out and I am currently testing as it seems to work.

 

Measure = MAXX(DISTINCT(Table1[Country]),MAX(Table1[Weight]))
SumWeight = SUMX(DISTINCT(Table1[Country]),[Measure])

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.