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.
I want to be able to fillter my visual using a measure which has around 100 names.
Field is EmployeeName.
How can I create a measure to filter all these 100 names?
ex in SQL
where EmployeeName in ("Rashford", "Ronaldo", "Messi","Suarez"...."Neymar")
exactly the same way. Check for presence of the selected column value in the list and set the measure output to 1 or 0. Filter the visual by the measure to equal 1.
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 |