Forum Discussion
Solved
Filters not applied in my table
Hi Guys, Below is my Model Diagram, I just need to create a calculated table for Employee id = 3. Please only use "Employee Id" column from "EMPLOYEE HIEARACHY" Table. Attached the file in ...
Employee Not Procured Item count = Var table1 = CALCULATETABLE(VALUES('Order Details'[ProductID]), TREATAS(VALUES('Employee Hierarchy'[Employee ID]),Employees[EmployeeID]) ) return countrows(except(VALUES(Products[ProductID]),table1))
I appreciate your code work 🙂