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.
Try:
Provider Payout =
VAR _IF = IF([CPT Co Sign Value]>=0, [Visits] * [CPT Co Sign Value]))
RETURN
SUMX(SUMMARIZE(Sheet1, Sheet1[Co-Sign Bonus], "Billed CPT",
_IF), [_IF])
If that doesn't work, you might need to split it into 2 measures:
1) If measure = IF([CPT Co Sign Value]>=0, [Visits] * [CPT Co Sign Value]))
2) Provider Payout =
SUMX(SUMMARIZE(Sheet1, Sheet1[Co-Sign Bonus], "Billed CPT",
[If measure], [If measure])
