Forum Discussion

eddd83's avatar
eddd83
Resolver I
5 years ago
Solved

keep filter ( ) + filter ( all ( ) )

slicer:  Date[Date] = Oct 24, 2020 (saturday)   Report: Location Product Posted Price Chicago Apples 1.25 Chicago Banana 1.75 Chicago Carrots 1.61   Produce Table: Lo...
Need Help
  • smpa01's avatar
    smpa01
    5 years ago

    eddd83 not sure if you would like it, but I solved it using a different measure.

     

     

    Revised Price := 
VAR _1 = MAX(Dates[Date])
VAR _2 = CALCULATE(MAX(Dates[Date]),FILTER(ALL(Dates),Dates[Date]<=_1&&[Max Revised date]<>0))
VAR _3 = CALCULATE([MaxPrice],ALL(Dates[Date]),Dates[Date]=_2)
RETURN _3

     

amitchandak's avatar
amitchandak
Super User
5 years ago

eddd83 , Not very clear. You can have a date table with following columns

 

WeekDay = WEEKDAY([Date],2) //monday
Start of Week = [Date] -[WeekDay]+1 //monday
Week Rank = RANKX(all('Date'),'Date'[Week Start date],,ASC,Dense)

 

Measure  =

var _max = maxx(allselected('Date'), 'Date'[Week Rank])

return

Calculate(min(Produce[Posted Price]) , filter(All('Date'), 'Date'[Week Rank]) =_max))

 

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.