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.
Hi All... I have 2 tables.
Created a measure is to find distinct count of "Acct" in table 1:
Count Unique Acct = DISTINCTCOUNT(Table1[Acct]) or should it be count row?
I also need help in trying to find the following:
1. Find matches of "Acct" in Table 2 to "Acct" in Table 1 if so then return distinct count or count row.
2. Second part similar to previous #1 but to find distinct count for specific region ie "East" in Table 2 is 2 as 2 matches to table 1 and "West" should be 1 and so on.
Thank you all for your help.
Solved! Go to Solution.
Thanks @v-yangliu-msft.
I was thinking something more along the line of the following, which appeared to work.
And for specific region be like this....
Hi @Tevon713 ,
Here are the steps you can follow:
1. Create measure.
Measure =
var _select=SELECTCOLUMNS('Table2',"1",[Acct])
var _table1=
SUMMARIZE('Table1','Table1'[Acct],'Table1'[Region],
"Flag",IF('Table1'[Acct] in _select,1,0))
return
IF(
MAX('Table2'[Region]) in SELECTCOLUMNS(_table1,"Region",[Region]) ,
COUNTX(FILTER(_table1,[Flag]=1),[Region]))
2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Thanks @v-yangliu-msft.
I was thinking something more along the line of the following, which appeared to work.
And for specific region be like this....
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 |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |