Forum Discussion

IamTDR's avatar
IamTDR
Icon for Responsive Resident rankResponsive 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's avatar
    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

     

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

Hi,

Share the link from where i can download your PBI file.

  • IamTDR's avatar
    IamTDR
    Icon for Responsive Resident rankResponsive Resident
    5 years ago

    Not sure how to do that, plus I have only real data that I cannot share online.