How calculate number of True values shown in a column in a filtered table?

[AnnaH11]

Hi,

I have a table where we have one column with Engagements and one column with a company that belongs to this engagement. An engagement can have several companies, ie there can be several rows with the same engagement. I also have made a column that gives the value true if one or more of the same engagement have a contact registered in the row.

I have a table and a Multi-row card in the Report view, see picture below.

I have filtered so I have 5 engagements, and in some cases there are two companies for that engagement. So in total 7 companies for these 5 engagements. So long all is good.

But I would need a way to get the number of True in the Client contacts column, in this case 5. Ie if 5 Engagements show in the table, how many Trues are in the Client contacts column. Anyone who might know how to do this?

Kind regards,

Anna

[Moetazzahran]

Hello, 
Can you please provide a sample dataset?

[AnnaH11]

Hi, it can look like this

[xifeng_L · Accepted solution]

Hi @AnnaH11 

You can try this measure.

Measure = CALCULATE(DISTINCTCOUNT('Table'[Engagement]),'Table'[Client Contact]="TRUE")

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

Thank you~