Forum Discussion

Responsive Resident

5 years ago

Solved

Need Help Summing a Total

Hi I am trying to the PIU column to sum to 450 instead of 204. Is this possible? I have 23 distinct ProductIDs and two distint ProgCodes that will always be 200/250. Not sure how to proceed...

Need Help

DataZoe
5 years ago
IamTDR This is a bit different than the Test_Data 🙂 Try this measure:

PIU 2 =
VAR _t =
    SUMMARIZE (
        Test_Data,
        Test_Data[AccountNumber],
        Test_Data[ProgramCode],
        "PIU", MIN ( [ProgramAdmissions] )
    )
VAR _d =
    SUMX ( _t, VALUE ( [PIU] ) )
RETURN
    _d

DataZoe

Microsoft Employee

5 years ago

IamTDR This is a bit different than the Test_Data 🙂 Try this measure:

PIU 2 =
VAR _t =
    SUMMARIZE (
        Test_Data,
        Test_Data[AccountNumber],
        Test_Data[ProgramCode],
        "PIU", MIN ( [ProgramAdmissions] )
    )
VAR _d =
    SUMX ( _t, VALUE ( [PIU] ) )
RETURN
    _d