Need help on dax measure

[Pmrs]

Hi Team,

Good day,

I need dax measure for Totalexceededcalls 

Totalexceededcalls=anycall made morethan total target calls

Thanks in advance

[v-nmadadi-msft]

Hi @Pmrs 

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the community members for the issue worked. Please do let us know if you have any further queries.

Thanks and regards

[v-nmadadi-msft]

Hi @Pmrs ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Thank you.

[v-nmadadi-msft]

Hi @Pmrs 

May I ask if you have resolved this issue? If not, Please feel free to contact us if you have any further questions.

Thank you.

[v-nmadadi-msft]

Hi  @Pmrs ,
Thanks for reaching out to the Microsoft fabric community forum.

I have used this DAX formula to generate TotalExceededCalls

TotalExceededCalls =

SUMX (

    ADDCOLUMNS (

        VALUES ( Target[rep] ),

        "ExceededFlag",

            IF (

                CALCULATE(SUM(Target[Total calls])) > CALCULATE(SUM(Target[Totaltarget])),

                1,

                0

            )

    ),

    [ExceededFlag]

)

This is the generated output:

Uploaded the .PBIX file for reference as well.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thank you

[Pmrs]

Hi 

Thank you for your response.

The output should be total exceeded calls. If a rep exceeds total target calls ex: target call is 100

And a rep exceeds 3 calls then the output should be 103 not as a flag 0 or 1. Could you please help on this

[v-nmadadi-msft · Accepted solution]

Hi @FBergamaschi ,

Updated the dax as per the requirement

TotalExceededCalls = 
SUMX (
    ADDCOLUMNS (
        VALUES ( Target[rep] ),
        "ExceededFlag",
            IF (
                CALCULATE(SUM(Target[Total calls])) > CALCULATE(SUM(Target[Totaltarget])),
                CALCULATE(SUM(Target[Total calls])) - CALCULATE(SUM(Target[Totaltarget])),
                0
            )
    ),
    [ExceededFlag]
)

here is the corrected output

If this post helps, then please consider Accepting as solution to help the other members find it more quickly and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thank you

[FBergamaschi]

Hi Pmrs

please can you clarify if you need a measure or a calculated column?

As a measure

SUMX (
              Table,
               IF ( 
                       Table[TotalCalls] > Table[TargetCalls],
                        Table[TotalCalls] - Table[TargetCalls]
                )
)

as a column

IF ( 
                       Table[TotalCalls] > Table[TargetCalls],
                        Table[TotalCalls] - Table[TargetCalls]
                )

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

[Greg_Deckler]

@Pmrs As a calculated column this would be:

Column = MAX( [Totaltargetcalls] - [Total calls], 0 )