Forum Discussion

visheshjain's avatar
visheshjain
Icon for Impactful Individual rankImpactful 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
visheshjain's avatar
visheshjain
Icon for Impactful Individual rankImpactful Individual
3 years ago

Hi johnt75,

 

The visual is giving an error.

 

P.S. 2 step and 1 step are my start and end dates.

johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

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

  • visheshjain's avatar
    visheshjain
    Icon for Impactful Individual rankImpactful 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
      Icon for Super User rankSuper 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
        Icon for Impactful Individual rankImpactful 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?