Forum Discussion
Adidas
Helper I
Helper ICalculating a dynamic anti join table
I have two tables in my power bi model: a. SalesFact table which contains sales per employee by dates and b.SalesEmployees which hold the salesperson's details My goal is to show for each date a li...
Hi Adidas ,
I think this is what you want.
Pbix file is attached with the solution
https://community.powerbi.com/t5/Desktop/Count-of-Customers-with-no-Sales/td-p/589155
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
amitchandak
Super User
Super UserAdidas , you can use inside a measure, but costly stuff for measure
antijoin table =
countx(
EXCEPT (
SELECTCOLUMNS ( SalesPersons, "ID", SalesPersons[worker id] ),
SELECTCOLUMNS ( 'Salesfact', "ID", 'Salesfact'[worker id] )
) ,[worker id] )
AdidasHelper I
Helper IThanks amitchandak
I created the measure as you suggested
measure =
countx(
EXCEPT (
SELECTCOLUMNS ( SalesPersons, "ID", SalesPersons[worker id] ),
SELECTCOLUMNS ( 'Salesfact', "ID", 'Salesfact'[worker id] )
) ,[ID] )
How can I show now the list of employees with no daily sales?