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

     

smpa01's avatar
smpa01
Community Champion
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

 

  • smpa01's avatar
    smpa01
    Community Champion
    5 years ago

    eddd83 did you try the solution provided?