Doubt with Calculation

[Anonymous]

Hi all! I have a table like this:

Incoming mails and public comments are two calculated columns (1 yes 0 no) related to metric and type columns.

What I want to see is the next kpi:

Number of public comments from TICKETS with an incoming mail

Any idea?

Thanks in advance!

[v-lili6-msft]

hi, @Anonymous 

Wasn't 100% clear what you were looking for based on the screenshot, What is your expected output?

If this formula could help you

Measure = CALCULATE(SUMX(Table, [public comments]), ALLEXCEPT(Table, ticket_id))

If not your case, please share Sample data and expected output.
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Best Regards,

lin