Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have 2 tables tbl1 as master and tbl2, with a relation of 1 to many tbl1 on tbl2 on code.
tbl1
Code. Name
01 John
02 Robert
03 Jill
04 Mary
05 Alex
tbl2
Code. Name
01 John
01 John
04 Mary
03 Jill
03 Jill
03 Jill
Output required
Code. Name. Occurence.
01. John. 2
02. Robert. 0
03. Jill. 3
04. Mary. 1
05. Alex. 0
Can someone please help me? Thanks
Solved! Go to Solution.
Hi Jaweed,
Insert a column in table 1 and try this dax.
Hope this would help,
Sukhi
Hi Jaweed,
Insert a column in table 1 and try this dax.
Hope this would help,
Sukhi
Hi @Jaweed ,
You can create the following measure:
User | Count |
---|---|
124 | |
106 | |
99 | |
63 | |
59 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |