Forum Discussion

RyanNewportJP's avatar
RyanNewportJP
Frequent Visitor
1 year ago
Solved

Force All Filter Context

Hi all,   I found some DAX on the web that calculates new vs. repeat users. However, the DAX only works for users who bought within the sliced timeframe, not the entire dataset.    The code is be...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    If you want the static result not filtered by slicers/filters, the idea to create a calculated table to summarize the number in advance is doable. And this can improve the performance of measures because they can count easily from this new table. 

     

    But your table code is not correct. You could try below code instead. 

    Customers and LTV = 
   Summarize('Table','Table'[CustomerID],"LTV",SUM('Table'[ProductTotal]),"NumOrders",DISTINCTCOUNT('Table'[OrderNumber]))

     

    Best Regards,
    Jing

bhanu_gautam's avatar
bhanu_gautam
Super User
1 year ago

RyanNewportJP , Try using remove filter than, Can you share sample data for testing

 

dax
Repeat Customers =
COUNTROWS(
FILTER(
DISTINCT(Table[CustomerID]),
CALCULATE(
DISTINCTCOUNT(Table[OrderNumber]) > 1,
REMOVEFILTERS(Table)
)
)
)

One-Time Customers =
COUNTROWS(
FILTER(
DISTINCT(Table[CustomerID]),
CALCULATE(
DISTINCTCOUNT(Table[OrderNumber]) = 1,
REMOVEFILTERS(Table)
)
)
)

RyanNewportJP's avatar
RyanNewportJP
Frequent Visitor
1 year ago

Sorry, I was looking at the wrong dashboard. It now isn't showing any orders as new and all as repeat:

 

I tried chaing one-time customrs's operator to ==, but nothing changed...