Forum Discussion

Pmrs's avatar
Pmrs
Regular Visitor
1 year ago
Solved

Need help-DAX code

Hi Team, Need a help on creating dax for Totalexceededcalls. Logic: calls made morethan total target calls.   Attaching the file for reference
  • v-tejrama's avatar
    v-tejrama
    1 year ago

    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's avatar
v-tejrama
Community Support
1 year ago

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's avatar
    v-tejrama
    Community Support
    1 year ago

    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's avatar
      v-tejrama
      Community Support
      1 year ago

      Hi Pmrs ,

       

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

       

      Thank you.

       

      • v-tejrama's avatar
        v-tejrama
        Community Support
        1 year ago

        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.