Need help-DAX code

[Pmrs]

Hi Team,

Need a help on creating dax for Totalexceededcalls.

Logic: calls made morethan total target calls.

Attaching the file for reference

[Poojara_D12]

Hi @Pmrs 

To create a DAX measure called TotalExceededCalls, the goal is to count or sum the number of calls that exceeded the assigned Target Calls for each context—such as per agent, region, or time period. The logic is to compare the Actual Calls Made against the Target Calls, and identify only those instances where the actual calls are greater than the target.

Assuming you have a table (e.g., CallData) with columns like [CallsMade] and [TargetCalls], you can write a DAX measure like this:

TotalExceededCalls = 
CALCULATE(
    COUNTROWS('CallData'),
    FILTER(
        'CallData',
        'CallData'[CallsMade] > 'CallData'[TargetCalls]
    )
)

This measure filters the table to only those rows where the number of calls made exceeds the target and then counts those rows. If instead you want to sum the exceeded amount, use:

TotalExceededCalls = 
CALCULATE(
    SUMX(
        FILTER('CallData', 'CallData'[CallsMade] > 'CallData'[TargetCalls]),
        'CallData'[CallsMade] - 'CallData'[TargetCalls]
    )
)

This version returns the total number of extra calls made beyond the target across all relevant rows. The choice between counting records or summing the excess depends on your reporting need. This logic can be visualized across agents, teams, or dates to track performance beyond targets.

[v-tejrama]

Hi @Pmrs,

Thanks for reaching out to the Microsoft fabric community forum.

I’ve replicated your scenario in Power BI and achieved the expected result using your logic:identifying agents who made more calls than their target.

I entered sample data with Agent, CallsMade, and TargetCalls columns.

To flag agents exceeding their targets, I added a calculated column:

ExceededFlag = IF('Table'[CallsMade] > 'Table'[TargetCalls], 1, 0)

This returns 1 if CallsMade is greater than TargetCalls.

Next, I created a measure to count the agents who exceeded their targets:

TotalExceededCalls = CALCULATE(COUNTROWS('Table'), 'Table'[CallsMade] > 'Table'[TargetCalls])

Using a table and a card visual in Power BI, I confirmed that 4 agents surpassed their targets, exactly as required.

Please find the attached pbix file for your reference.

If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it.

Best Regards,
Tejaswi.
Community Support

[v-tejrama]

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

Hi @Pmrs ,

I hope the information provided has been useful. Please let me know if you need further clarification

Thank you.

[v-tejrama]

Hi @Pmrs ,

I wanted to follow up and see if you had a chance to review the information shared. If you have any further questions or need additional assistance, feel free to reach out.

Thank you.

[speedramps]

I want to help you but your description is too vague AND no file it attcvhged for reference.

Please write it again.

You will get a quicker and better response without misunderstandings if you put time and effort into carefully writing a clear problem description with example input and output data. Look forward to helping you when this information is forthcoming

* Please DO give a simple non-technical functional description of what you want
* Keep it simple and break large projects into smaller questions and ask just one question per ticket.
* Rename columns to user friendly names. Avoid your own system jargon that we may not understand.
* Most importantly please provide example input data as table text (not a screen print) so helpers can import the data to build a solution for you. (Learn how to share data below)
* Provide the example desired output, with a clear step-by-step description of calculations and the process flow.
* Take time and care to use the same table and field names in the input, output and description so we can understand your problem and help you.
* Remove any unneeded tables, rows or columns which may cause confusion. Keep it short and concise with the minimal information regarding the key problem.
* Remember not to share private data ... we don't want you to get into trouble. ‌‌
* Please click the thumbs up button for these helpful hints and tips. Thank you.

Learn how to attach data in the forum using OneDrive:-
* Save your file in a OneDrive folder
* Right click on the file and click the “Share” blue cloud icon
* Click the bottom “Copy” button
* Click” Anyone with link can edit”
* Click “Can Edit”
* Click “Can View”
* Click “Apply” button
* Click “Copy”
* Paste the generated link via the forum, email, chat, or any other method.
* Helpers can then download your data, build a solution and share it back.

Learn how to attach data in the forum using Dropbox:-
1. Open Dropbox: Access the Dropbox folder on your computer or through the Dropbox web interface.
2. Select File/Folder: Find the file or folder you want to share.
3. Click Share (or Get Link): Look for a "Share" option or a similar "Get Link" option.
4. Choose Permissions: Decide whether to allow "view only" or "view and download" access.
5. Copy and Share: Copy the generated link and share it with anyone via the forum, email, chat, or any other method.