topic Need help on dax measure in DAX Commands and Tips

Need help on dax measure

Pmrs — Fri, 27 Jun 2025 16:08:34 GMT

Hi Team,

Good day,

I need dax measure for Totalexceededcalls

Totalexceededcalls=anycall made morethan total target calls

Thanks in advance

Re: Need help on dax measure

Greg_Deckler — Fri, 27 Jun 2025 18:32:24 GMT

Pmrs As a calculated column this would be:

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

Re: Need help on dax measure

v-nmadadi-msft — Tue, 01 Jul 2025 18:08:33 GMT

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

Re: Need help on dax measure

Pmrs — Mon, 30 Jun 2025 10:13:59 GMT

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

Re: Need help on dax measure

FBergamaschi — Tue, 01 Jul 2025 18:01:28 GMT

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

Re: Need help on dax measure

v-nmadadi-msft — Tue, 01 Jul 2025 18:23:47 GMT

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

Re: Need help on dax measure

v-nmadadi-msft — Fri, 04 Jul 2025 04:45:06 GMT

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.

Re: Need help on dax measure

v-nmadadi-msft — Mon, 07 Jul 2025 08:42:48 GMT

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.

Re: Need help on dax measure

v-nmadadi-msft — Thu, 10 Jul 2025 11:43:52 GMT

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