Cross filter report page based on measure selection
Hello PB Comunity, This is my first question ever. Hopefully you DAX geniuses can help me out here. I have a measure counting the new customers: Count new customers = VAR CustomersWithNewDate = CALCULATETABLE ( ADDCOLUMNS ( VALUES ( 'Sale invoices'[customer_id] ), "@NewCustomerDate", [Sale invoices - First date by partner] ), ALLSELECTED ( Customers ), ALLSELECTED ( 'Calendar' ) ) VAR CustomersWithLineage = TREATAS ( CustomersWithNewDate, 'Sale invoices'[customer_id], 'Sale invoices'[date_id] ) VAR Result = CALCULATE ( DISTINCTCOUNT ( 'Sale invoices'[customer_id] ), KEEPFILTERS ( CustomersWithLineage ) ) RETURN Result This works and I use this in a barchart on my report: Now when I click on one of the bars of this chart I want the report to be crossfiltered to shwo only the data for those new customers. But instead of showing only the data for the new customers the report only gets crossfiltered by the selected month and not only new customers. I know that there should be a way to do this but i cannot find a way to do this. I have 3 tables: - Sale Invoices - Customers - Calendar There are two excisting relationships: - 'Sale invoices'[date_id] = 'Calendar'[date_id] - 'Sale invoices'[customer_id] = 'Customers'[customer_id] I would be very greatfull if someone could help me out here! Thanks in advance!
