I have three tables related to each others (two tables many-to-many) : lets take this as an example
A person has many resources
I wanted to count for example : for every resource the number of people who has this resource, with a special condition on person for example firstname starts with "j".
I try many functions like filter or others but theese function only filter into the same table.
how can i use join on couting ?
Solved! Go to Solution.
Hi khalilliraqui,
According to your description, you want to get the count of resource owner persons which first name start with “j”?
If as I said, you can follow below steps):
‘Person’:
’Personal Source’:
‘Resource Type’:
Recoure Count of Person Start with 'j' = DISTINCT( SELECTCOLUMNS('Personal Source',"Resource Type",RELATED('Resource Type'[Name]),"Count",COUNTX(FILTER('Personal Source','Personal Source'[Resource Type ID]=EARLIER('Personal Source'[Resource Type ID])&& LEFT(RELATED(Person[First Name]))="j"),'Personal Source'[Person ID])))
Reference:
Regards,
Xiaoxin Sheng
Hi khalilliraqui,
According to your description, you want to get the count of resource owner persons which first name start with “j”?
If as I said, you can follow below steps):
‘Person’:
’Personal Source’:
‘Resource Type’:
Recoure Count of Person Start with 'j' = DISTINCT( SELECTCOLUMNS('Personal Source',"Resource Type",RELATED('Resource Type'[Name]),"Count",COUNTX(FILTER('Personal Source','Personal Source'[Resource Type ID]=EARLIER('Personal Source'[Resource Type ID])&& LEFT(RELATED(Person[First Name]))="j"),'Personal Source'[Person ID])))
Reference:
Regards,
Xiaoxin Sheng
Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.
Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!
User | Count |
---|---|
212 | |
53 | |
45 | |
41 | |
41 |
User | Count |
---|---|
270 | |
210 | |
72 | |
70 | |
65 |