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 Team,
I just have to find whether a particular employee's data is there in the table by filtering month and task. I have created a measure as follows.
Solved! Go to Solution.
Hi,
The above mentioned measures return a value even if the employee id is not selected. This measure should return a value only when the employee id is selected otherwise it can return blank.
Thanks,
Jos
Can you make your slicer single select or do you need to have the ability to select several employees?
If that is the case, how do you want the logic to behave when there is more than one employee selected?
/ J
Single select would be fine. But if I make emp id slicer single select, is it possible for me to select other taks ? Report has to work in the following way:
User selects month first then task and then employee.
Thanks,
Jos
@Jos13 , try like
calculate(if(Max('Table'[EmpId]) =SELECTEDVALUE('Table'[EmpId]),"Yes","No"),values('Table'[EmpId]))
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |