Forum Discussion
Anonymous
4 years agoNot applicable
FILTER VALUES bringing blank result
Hi All, The following DAX measure is bringin back blank when I added it to a table visualisation. Leaver2 = CALCULATE(COUNTROWS(Person),FILTER(VALUES(Person[EmploymentStatus]),Person[Employme...
- 4 years ago
Hey Anonymous ,
First of all, I recommend that you create your Status column on Power Query (you can use the Conditional Column).
After that, the mesaure to count the values of the Inactive can be like:count_inactives = CALCULATE(COUNTROWS(Manager),FILTER(Manager, Manager[Status] = "Inactive"))
*** manager is my table nameIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Regards,
Marcel Magalhaes
Anonymous
4 years agoNot applicable
marcelsmaglhaes
Super User
4 years agoHey Anonymous
It was a pleasure to help!
Regards,
Marcel