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.
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?
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] )RETURNSUMX(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])-----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.PaulDBrown Oh my goodness, that worked!!! Thank you so much!!!!
Can you provide a screenshot of the model to see the relationships between the tables?