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.
Hello
So i'm doing some analysis on my company's clients and some of them have projects with multiple sectors within our company.
I want to filter my data to show clients who have projects with one particular sector.
Thanks in advance.
Solved! Go to Solution.
Hi @SDigital,
Based on my understanding, you want to display those clients who have only one project with only one sector, right?
If so, you can create a measure similar to below, add this measure to visual level filter and set its value to 1.
check1 = IF ( CALCULATE ( DISTINCTCOUNT ( Sheet1[Project] ), ALLEXCEPT ( Sheet1, Sheet1[Client] ) ) = 1 && CALCULATE ( DISTINCTCOUNT ( Sheet1[Sector] ), ALLEXCEPT ( Sheet1, Sheet1[Client], Sheet1[Project] ) ) = 1, 1, 0 )
Best regards,
Yuliana Gu
Hi @SDigital,
Based on my understanding, you want to display those clients who have only one project with only one sector, right?
If so, you can create a measure similar to below, add this measure to visual level filter and set its value to 1.
check1 = IF ( CALCULATE ( DISTINCTCOUNT ( Sheet1[Project] ), ALLEXCEPT ( Sheet1, Sheet1[Client] ) ) = 1 && CALCULATE ( DISTINCTCOUNT ( Sheet1[Sector] ), ALLEXCEPT ( Sheet1, Sheet1[Client], Sheet1[Project] ) ) = 1, 1, 0 )
Best regards,
Yuliana Gu
Thanks for answering my query. This formula is almost there but i want to show clients that have one or more projects with one sector.
Thanks again!
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 |
---|---|
111 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |