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,
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!
Solved! Go to 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,
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
Thanks Lydia! That worked well.
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 |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |