I have one total that is not summing

[jonnyA]

@parry2k 

Hello again,

I have a matrix where only one of my "Co Sign Amount" 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 the "Co Sign Amount" ...

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]))

But for some reason it is not summing one of these $25 ...

[PhilipTreacy]

@jonnyA 

We really need the raw data. Screenshots are useful to get an idea of the issue but you can't expect us to recreate your entire dataset to try to figure out the issue.

regards

Phil

[jonnyA]

@PhilipTreacy 

Here is a formula that did work ... via @parry2k 

Provider Payout 5 = SUMX(Sheet1, [If measure])

If Measure = IF([CPT Co Sign Value]>=0, [Visits] * [CPT Co Sign Value]

[Icey]

Hi @jonnyA ,

Glad to hear that. Please accept your reply as a solution so that people who may have the same question can get the solution directly.😉

Best Regards,

Icey

[Icey]

Hi @jonnyA ,

The total values are no problem. Please check if this measure gives you the expected results.

Provider Payout =
VAR ProviderPayout =
    FILTER (
        SUMMARIZE (
            Sheet1,
            Sheet1[Co-Sign Bonus],
            "Billed CPT", [Visits] * [CPT Co Sign Value]
        ),
        [Billed CPT] > 0
    )
RETURN
    SUMX ( ProviderPayout, [Billed CPT] )

Best regards

Icey

If this post helps, then consider Accepting it as the solution to help other members find it faster.

[jonnyA · Accepted solution]

@Icey

Thank you for responding!  Your formula did not work.  

Here is a formula that did work ...

Provider Payout 5 = SUMX(Sheet1, [If measure])

If Measure = IF([CPT Co Sign Value]>=0, [Visits] * [CPT Co Sign Value])

[parry2k]

@jonnyA share sample pbix file with the expected output, it is very hard to tell by looking at the code.

[jonnyA]

@parry2k , Does this photo help?  Is this what you are looking for?