Forum Discussion
alexpohl
3 years agoNew Member
Data Status independent from date slice
Hello Community,
I have searched for a long time for a solution of my problem, but I haven`t found the solution.
I have the following problem:
I want to become the data status independant of a slicer of my company
Slicer: Audi, VW, VWN, Seat......
My measure is the following:
LASTDATE('Markenübergreifend'[Delivery Day])
if i select the Brand, i become the right date, but if I slice the date in March, my date is in march, if I slice in april, the last date is the right date in april.
So far so good. I don`t know how delete the dependence between the date slice and my measure.
Thanks for your help and feedback.
Try
Last Date = CALCULATE ( MAX ( 'Markenübergreifend'[Delivery Day] ), REMOVEFILTERS ( 'Date'[Date] ) )Where 'Date'[Date] refers to the column you are using in the slicer