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 · Accepted solution]

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? How to provide sample data in the Power BI Forum - Microsoft Fabric Community

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

[v-achippa]

Hi @Rajirajesri,

As we haven’t heard back from you, we are closing this thread for now. If you have any further issue, please raise a new thread in the community forum and provide sample data that covers your issue or question completely in a usable format, we are ready to assist you on it.

Thank you for being part of Microsoft Fabric Community.

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