The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
---|---|
25 | |
12 | |
8 | |
8 | |
5 |
User | Count |
---|---|
28 | |
13 | |
12 | |
12 | |
6 |