Forum Discussion
Employee Status
Hi there - the main reason I had this calculation was to show the employee status only when an employee is selected...if you look at this picture below you will see that even if I dont select employee the first
'active' shows on the card. It works fine for active employees but when I use the above HANSON function and select an inactive employee the card is showing up as blank. I hope this makes sense and
would be able to help.
Hi sraj
Thanks for your reply, you can try this,
Status1 = SELECTEDVALUE('Table'[Column2])Status2 = IF(ISFILTERED('Table'[Column1]),MAX('Table'[Column2]))
Or if the name are 2 columns, you can try this,
Status3 = CALCULATE(MAX('TableNew'[status]),ALLSELECTED(TableNew))
Best Regards,
Community Support Team _ Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Ok, my actual names are two columns...last name and first name sorry that I didnt mention it earlier in my example. I tried both Status 1 & Status 2 measure, for status 1 I used exactly like what you have and for status 2 I used the last name and employee staus in your example. But this is what I see, the status 1 & status 2 card shows the measure you provided, the empty one in the center is the Hanson measure I have above which is showing blank...and the TERMINATED is the actual employee status which is the regular column. The 2nd print screen shows an active employees status.
Hi sraj
Thanks for your reply.
Yes, it only judges 'Table'[Column1] in measure Status2. So if your actual name have 2 columns, the measure Status2 will not work.
Does measure Status1 work OK? Is there anything I can help?
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.