Forum Discussion
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...
PIU =
VAR _min =
MIN ( Test_Data[ProgramAdmissions] )
VAR _max =
MAX ( Test_Data[ProgramAdmissions] )
VAR _same = _min = _max
RETURN
IF ( _same, _min, _min + _max )
This worked on my small sample data, but when I tried to use in my BI report I receive a "The end of the input was reached" message.
This worked on my small sample data, but when I tried to use in my BI report I receive a "The end of the input was reached" message.
First thanks for the feedback.
I am attempting to sum my PIU number but this number should be summed by AcctNumber and ProgramCode.
In the example picture, the sum should be 711.
Should I create a concatenate of accountnumber and programcode and use that field to sum my PIU?
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