topic Re: How calculate number of True values shown in a column in a filtered table? in DAX Commands and Tips

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

AnnaH11 — Tue, 04 Jun 2024 08:55:09 GMT

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

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

Moetazzahran — Tue, 04 Jun 2024 10:12:32 GMT

Hello,
Can you please provide a sample dataset?

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

AnnaH11 — Tue, 04 Jun 2024 10:35:56 GMT

Hi, it can look like this

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

xifeng_L — Tue, 04 Jun 2024 11:03:39 GMT

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~