Read slicer values, retrieve corresponding table column values and use them to check existence
Hi all, I am trying to retrieve a column values based on the selected single/multiple slicer values and use those data to check their existence in the other table. Let me put this out clearly. There are two tables i.e., Calendar and Employee data. The calendar has the following columns i.e., fiscal year, fiscal year period, date. Adding the screenshot below. Calendar table: The Employee table has Name, Location, Joined Date. Employee table: The slicer in the Power BI dashboard is added with the 'Fiscal year period' column from 'Calendar' table. If the user selects a particular fiscal period or multiple fiscal periods, the corresponding dates from the Calendar table have to be read in a dax calculation and check the existence of those date values in the Joined date column in the table 'Employee'. For instance, if the user selects 2025 P3 and 2025 P4 from the slicer, then the corresponding dates from 3rd March to 4th May have to be read and check if any of those values exist in the column from other table i.e., in Joined date from Employee table. Could you please help me with a dax calculation/measures for this scenario? Any suggestions will be appreciated. Thanks! Microsoft EnterpriseDNA
INTERSECT between 2 Tables with different Filter Values
Hi Everyone, I would appreciate any assistance you could provide. I have two tables that share a Many to Many relationship. The first is a record of all activities created by our staff and the second is a list of all policies sold. (The actual tables are considerably larger and contain many more columns.) Activities: need to filter for only TF activities Client Code Activity Type Client Name A123 TF Adam B229 TF Bob C234 CT Charles E762 NO David A123 TF Adam B229 NO Bob C234 CT Charles A123 CT Adam E762 TF David Policies Sold: need distinct policy numbers Client Code Policy Number Premium A123 11111 $ 100.00 B229 22222 $ 300.00 C234 33333 $ 200.00 E762 44444 $ 900.00 A123 11111 $ 50.00 A123 55555 $ 400.00 I need to build a formula that shows a count of all policies sold only for those client codes where a TF activity was entered. If more than one unique Policy Number exists on a client code I need to count each of these, but I would not want to count duplicates of the same policy number on the same client code.Virtuel table with a measure
Hi everyone , I want to creat a table based on two tables : Sales / Custumers ( i have for each custumer the name of the sales rep responsable for the account) I just want to creat a table that gives me the number of custmers that had purchase minimum 100$ by sales rep I'm struggeling with calculatetable selectcolumns but it's an epic fail ^^ Thanks by advance BR,
