Need Dax logic to create total exceedcalls

[Rajirajesri]

Hi Team,

I have to create TotalExceedCalls measure= any calls made more than Totaltargetcalls.

Totaltargetcalls is a measure and Total call is a measure, based on these 2 measures I need dax logic.

I used the below logic but the result is not correct.

Totalexceededcalls=

calculate(sum(call[Totalcall],

Filter(call,call[Totalcall]>call[Totaltargetcalls]))

Thanks in advance

[v-achippa]

Hi @Rajirajesri,

Thank you for reaching out to Microsoft Fabric Community.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-....Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447....

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @Rajirajesri,

As we haven’t heard back from you, we wanted to kindly follow up to check if your issue is resolved?

If not please provide sample data that covers your issue or question completely, in a usable format.
Do not include sensitive information and anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Thanks and regards,

Anjan Kumar Chippa

[FBergamaschi]

Please provide a sample table that we can copy and import in Power BI to create the solution

Thanks