New Customers based on Slicer

Anonymous — Thu, 07 May 2020 00:30:22 GMT

I want to calculate new customer Trend on date column based on slicer (Type).

When Slicer selection Type = "ALL", this customer should show as new on 1/1/2020

When Slicer selection Type = A, this customer should show as new on 1/1/2020

When Slicer selection Type = B, this customer should show as new on 1/2/2020

When Slicer selection Type = C, this customer should show as new on 2/1/2020

I tried using Earlier DAX function but Earlier is not helping with the slicer. Can we have a dynamic measure to get the new customers based on slicer selection option.

Re: New Customers based on Slicer

v-lili6-msft — Thu, 07 May 2020 04:19:53 GMT

hi Anonymous

First, you should know that:

1. Calculation column/table not support dynamic changed based on filter or slicer.
2. Measure can be affected by filter/slicer, so you can use it to get dynamic summary result.

https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/

Second, for your case, you could try this measure

Measure = IF(SELECTEDVALUE('Table'[Date])=CALCULATE(MIN('Table'[Date]),ALLSELECTED('Table')),"New")

Measure 2 = IF(SELECTEDVALUE('Table'[Date])=CALCULATE(MIN('Table'[Date]),FILTER(ALLSELECTED('Table'),'Table'[ID]=MAX('Table'[ID]))), "New")

Result:

and here is sample pbix file, please try it.

Regards,

Lin

topic New Customers based on Slicer in DAX Commands and Tips

New Customers based on Slicer

Re: New Customers based on Slicer