Data Table Creation with FILTER DISTINC and COUNT

Hi MackenzieGENUS ,

First of all, many thanks to vicky_  for your very quick and effective replies, and I will give some additions below:

1.Create the simple table.

2.Use the distinct dax to create the Table B.

Table B = distinct('Table'[AGEMO])

3.Create the relationship between the Table and Table B.

4.Create the new column to count the ID from Table.

COUNT ID = CALCULATE(COUNTROWS('Table'), 'Table'[BINDER] = 0)

5.Drag the column into the table visual. The result is shown below.

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.