Cross filter report page based on measure selection

[QuentinRijkers]

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!

[QuentinRijkers]

Hi @lbendlin,

Thanks for your response. Is there a work around? I can not imagine i am the only one who wants to dynamicly count the new customers and be able to crossfilter to see who they are and what there activity is.

Using calculated column will make it no longer dynamic so I am trying to find a way how to keep it dynamic but still corssfilter in some way. 

Thanks in advance!

[lbendlin]

add the measure as a filter to all visuals on the page.

[lbendlin]

Measures can only filter individual visuals, not whole pages.