Forum Discussion
Filter table based on relative date and specific column values from same table
Thank you for your answer, however I was hoping for a more dynamic solution. This solution only works for cross selling analysis, but we would also like to to have these filter options for all of our tables (products, appointments etc.) and also the combination between tables (customers who bought product A and after x amount of days had appointment B). Therefore we hope there is an option of doing this without duplicating all the tables.
Anonymous,
You should be able to achieve this with virtual tables in DAX measures. The concept is to create a virtual table that meets the conditions, and then further filter it for the additional conditions. The intersection of the two tables would be a table expression that can be used in a CALCULATE measure. You'll need a clone of the Product table (no relationships) for the second Product slicer. The TREATAS function would be an option for applying the Product filter from the cloned Product table to the main Product table.
Are you able to share a sanitized pbix via one of the file services like OneDrive?