Forum Discussion

alexpohl's avatar
alexpohl
New Member
3 years ago
Solved

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

2 Replies

  • 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