Forum Discussion

IamTDR's avatar
IamTDR
Responsive Resident
8 years ago
Solved

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 ...
Need Help
  • IamTDR's avatar
    IamTDR
    8 years ago

    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])

IamTDR's avatar
IamTDR
Responsive Resident
8 years ago

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

IamTDR's avatar
IamTDR
Responsive Resident
8 years ago

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])