Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
I have a table A:
ID AGEMO BINDER
1 1 0
2 1 1
3 6 0
4 8 0
8 21 0
and I created a second table (TABLE B) from the following command:
Solved! Go to Solution.
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.
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.
If you haven't created a relationship between table A and table B, then that will happen.
I would also suggest just creating the table with the countID column already included -
try changing your table constructor to something like:
ID Target = ADDCOLUMNS(distinct('Table A'[AGEMO]), "COUNT ID", CALCULATE(COUNTROWS('Table A'), TABLE A'[BINDER]=0))
User | Count |
---|---|
13 | |
8 | |
8 | |
7 | |
5 |
User | Count |
---|---|
21 | |
15 | |
15 | |
10 | |
7 |