Forum Discussion
my data not summing correctly
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.
Perhaps
Provider Payout =
VAR IfVar = IF([CPT Co Sign Value]>=0, [Visits] * [CPT Co Sign Value])
RETURN
SUMX(SUMMARIZE(Sheet1, Sheet1[Co-Sign Bonus], "Billed CPT",
IfVar), [Billed CPT])
Again, you might need to split this into two measures.
Thank you for your help on this issue I am having! I really appreciate the assisitance!!!
Ok, i think that worked a little bit, however, i am still off (I am off a a lot overall). The total I had questioned in my first request went from $65 to $80, but it should be $90.
Also, the total went from $20,520 (Provider Payout) to $175,800 with the new measure (Provider Payout 3)
I am not sure what you mean on splitting into 2 measures?
Thank you in advance!
Spltting into 2 measures would be:
1) If Measure = IF([CPT Co Sign Value]>=0, [Visits] * [CPT Co Sign Value])
2) Final measure:
Provider Payout =
SUMX(SUMMARIZE(Sheet1, Sheet1[Co-Sign Bonus], "Billed CPT",
[If measure]), [Billed CPT])
PS. Actually, seeing your original screenshot, which table is the period field and the other fields in the matrix from? You might need to include them in the SUMMARIZE expression.
Ok, thank you for the assistance!
I split the measure into 2 (Provider Payout 4), however, this time I get the same #'s as I initially had. We're back to $65. Should be $90. I do not understand why Power BI is not recognizing one of those $25 Provider Payouts?
Can you provide a screenshot of the model (relevant tables) & one of the visual to see the rows/ columns you are using?