dax formula using filter and OR

[Meg_Srikaran]

Hi,

I'm trying to count the no of funds assigned to three different people,i have managed to write the formula as below to filter for one of the person i figure i need to use an "OR" function to filter the other two people but unable understand how to do it .

Allocated to companyxyz = COUNTAX(filter(eoy,EOY[Display Name]="meg srikaran"),EOY[PKey])

Where we have the display name i need to filter all pkey's allocated to meg srikaran,vish srikaran ,rian srikaran.In the end i need the total count of pkey where the funds(pkey) assigned to the three people(display name).

Please let me know how i can acheive this ...thanks!

[v-yuezhe-msft · Accepted solution]

@Meg_Srikaran,

Please check if the following DAX returns your expected result, if not, please share dummy data of your table for us to analyze.

Allocated to companyxyz = COUNTAX(filter(eoy,EOY[Display Name]="meg srikaran"||EOY[Display Name]="vish srikaran"||EOY[Display Name]="rian srikaran"),EOY[PKey])

Regards,
Lydia

[Meg_Srikaran]

Thanks Lydia! That worked well.