Forum Discussion

jonnyA's avatar
jonnyA
Responsive Resident
5 years ago
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 ...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    5 years ago

    jonnyA 

     

    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's avatar
PaulDBrown
Community Champion
5 years ago

Can you provide a screenshot of the model (relevant tables) & one of the visual to see the rows/ columns you are using? 

jonnyA's avatar
jonnyA
Responsive Resident
5 years ago

PaulDBrown

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])
-----
  • PaulDBrown's avatar
    PaulDBrown
    Community Champion
    5 years ago

    jonnyA 

     

    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.

     

    • jonnyA's avatar
      jonnyA
      Responsive Resident
      5 years ago

      PaulDBrown Oh my goodness, that worked!!!   Thank you so much!!!!

  • PaulDBrown's avatar
    PaulDBrown
    Community Champion
    5 years ago

    Can you provide a screenshot of the model to see the relationships between the tables?

    • jonnyA's avatar
      jonnyA
      Responsive Resident
      5 years ago

      PaulDBrown , Sorry, I am new to Power BI.  I never knew this existed, but here you go!