Forum Discussion
Solved
my data not summing correctly
Hello, I have a matrix where only one of my "Co Sign Amount's" is not summing in the total. Do you know how I can make it sum? It is currently off $25. Here is the formula that I am using for ...
Ok, try this then:
If Measure = IF([CPT Co Sign Value]>=0, [Visits] * [CPT Co Sign Value])
Provider Payout 5 = SUMX(Sheet1, [If measure]).
If that doesn't work, then we will need to create the SUMMARIZE expression but including all the columns in the visual.
Hey! Let me know if this helps!
I gave you the measure I am using with the formula. Hopefully the screen shots help. Which also include the filters I am using! You can see all the measure that I amusing that are checked marked. Thank you again for all your help!
Co-Sign Bonus Amount =
[Visits] * MAXA(Sheet1[Co-Sign Bonus])
-----
If Measure = IF([CPT Co Sign Value]>=0, [Visits] * [CPT Co Sign Value])
-----
Provider Payout =
VAR ProviderPayout =
SUMMARIZE(Sheet1, Sheet1[Co-Sign Bonus], "Billed CPT",
[Visits] * [CPT Co Sign Value] )
RETURN
SUMX(ProviderPayout,
IF([CPT Co Sign Value]>=0, [Visits] * [CPT Co Sign Value]))
-----
Provider Payout 4 =
SUMX(SUMMARIZE(Sheet1, Sheet1[Co-Sign Bonus], "Billed CPT",
[If measure]), [Billed CPT])
-----
CPT Per Visit 3 = SUMX(
ADDCOLUMNS(
DISTINCT( vw_Table_Payments[CPT_Code]),
"CPTPerVisit", CALCULATE(DISTINCTCOUNT(vw_Table_Payments[voucher_number]))
),
[CPTPerVisit])
-----
Can you provide a screenshot of the model to see the relationships between the tables?