Forum Discussion
Calculated Table from based on values from another table
Hello, I have a table with Staff Name and Status Number as follows: Date Staff Name Status Number 01/11/2022 A 1 01/11/2022 A 2 01/11/2022 A 3 01/11/2022 A 4 01/11...
Then you can try something like this:
Calculated table =VAR __Filter =CALCULATETABLE( VALUES( Staff[StaffName] ), Staff[StaffNumber] = 2 )VAR __Result =FILTER (SUMMARIZECOLUMNS ( Staff[Date], Staff[StaffName] ),NOT ( Staff[StaffName] ) IN __Filter)RETURN __ResultBrMarius
Hi again 🙂
Ok, so what you want is that all staff name that equal to the same name as staff number 2 should be filtered away?
Marius
Then you can try something like this:
Calculated table =
VAR __Filter =
CALCULATETABLE( VALUES( Staff[StaffName] ), Staff[StaffNumber] = 2 )
VAR __Result =
FILTER (
SUMMARIZECOLUMNS ( Staff[Date], Staff[StaffName] ),
NOT ( Staff[StaffName] ) IN __Filter
)
RETURN __Result
Br
Marius
Hi Marius,
I get an empty table returned when i use the above.
Thanks!
Midhun
Hi again.
I have created a test .pbix file where this is working as expected, but I cant upload it on this website. Would you like me to send it on email?
BrMarius
Hello Marius. That would be great!
Can you please send it to [email protected]?