Use active slicer filter in measure

[lukham]

Hi,

I am trying to create a table with dates and values. The value is the same for each day and depends on the selected values of a slicer (single selection).

I tried to use the ALLSELECTED function but it ignores the slicer.

So I thought using a FILTER should work:

KPI_Targets = 
  VAR BaseCalendar =
    CALENDAR(DATE(2019,4,1), DATE(2021,31,12))
  RETURN
    GENERATE(
      BaseCalendar,
      VAR BaseDate = [Date]
      VAR Target = 
        CALCULATE(
          COUNT(Equipments[Id])/365,
          FILTER(Locations,[Title]=SELECTEDVALUE(Locations[Title]))
        )
     RETURN ROW(
       "Target",Target
     )
   )

On its own, SELECTEDVALUE(Locations[Title]) gives me the correct result but when I use it inside the formula above it does not work.

Any hints?

Thanks,

Lukas

[amitchandak]

@lukham , You can not use slicer value in the creation of a new table. They will act like static value

[lukham]

@amitchandak thanks for letting me know. Do you have an idea how I can achieve my goal (creating a table with dates in column 1 and a fixed value based on a slicer selection in column 2) instead?

[amitchandak]

@lukham , You can use Min/Max value of the table

Or you can create a var table in measure there you will able to use