Forum Discussion

visheshjain's avatar
visheshjain
Impactful Individual
3 years ago

Filter Slicer from Measure values

Hello eveyone, I have 3 tables. Calendar, Sale and Parameter. Parameter has values ranging from 1-24, which are the number on months I want to go back. I am trying to filter a slicer which has ...
Need Help
Show and Tell
Tips and Tricks
johnt75's avatar
johnt75
Super User
3 years ago

what does it show if you click on "see details" ?

visheshjain's avatar
visheshjain
Impactful Individual
3 years ago

As you can see the start and end dates are not blank as shown in the card visual below.

 

  • johnt75's avatar
    johnt75
    Super User
    3 years ago

    try creating a temporary table like

    tmp table =
ADDCOLUMNS ( VALUES ( 'Date'[date] ), "@step 1", [1 Step], "@step 2", [2 Step] )

    and you can then use the data view to look for dates where either step 1 or step 2, or both, are blank.

    • visheshjain's avatar
      visheshjain
      Impactful Individual
      3 years ago

      Hi johnt75,

       

      The new table did not work as start date is 31-12-1899 and the end date is blank.

      I think is cause of the parameters used in the measures, when using them in a table, there is no context.

       

      I tried modifying your code to use DATESBETWEEN() instead of CALENDAR(), it is not giving an error, but its not working either.

       

       

      Anything else that you can think of? 

      • johnt75's avatar
        johnt75
        Super User
        3 years ago

        You're right about the table lacking context. Try creating a table visual instead, use 'Date'[Date] and the two measures.