Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I want to count rows from a tableB by feltering from tableA too, in fact the tables has a commun clomuns, PHONE and WEEK.
I want to count rows that have the same PHONE and WEEK, here is the sql script I use in oracle to do that :
select count(B.phone) from tableB B, tableA A
where B.phone = A.phone and B.week = A.week;
Solved! Go to Solution.
Hi @imadelmouden,
Please add below measure into a card visual.
Measure= VAR temptable = FILTER ( CROSSJOIN ( TableA, SELECTCOLUMNS ( TableB, "Week2", TableB[Week], "Phone2", TableB[Phone] ) ), [Week] = [Week2] && [Phone] = [Phone2] ) RETURN COUNTX ( temptable, [Phone2] )
Best regards,
Yuliana Gu
Hi @imadelmouden,
Please add below measure into a card visual.
Measure= VAR temptable = FILTER ( CROSSJOIN ( TableA, SELECTCOLUMNS ( TableB, "Week2", TableB[Week], "Phone2", TableB[Phone] ) ), [Week] = [Week2] && [Phone] = [Phone2] ) RETURN COUNTX ( temptable, [Phone2] )
Best regards,
Yuliana Gu
i have three tables one is fact and two dimension.
i want distinctcount(table1[id]) by filtering table2[effective date] with user selected date range.
could you please suggest me dax for this.
I assume that you have set up the requied relaionship between Table A and Table B.
Try this measure.
Measure = CALCULATE( COUNT(TableB[Phone]), TableB[Phone]= TableA[Phone], TableB[Week] = TableA[Week] )
Thanks
Raj
@Anonymous when I did what you proposed, I got this error :
I have set a relationship between the two tables by PHONE number, and not the ID, because in the tableB you can find the same phone number in different rows by different week
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
139 | |
100 | |
95 | |
85 | |
63 |