Forum Discussion

salimgs's avatar
salimgs
Frequent Visitor
9 years ago

Accessing Slicer filtered values through columns

I have a Dates table that lists daily dates in a range. I put a slicer on it. I have a second table (lets call it Items) that is not related to Dates table but I need to have access to minimum and m...
Need Help
v-caliao-msft's avatar
v-caliao-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

salimgs,

 

You could create a measure like:

Measure = IF(MAX('Item'[forecast start date])>='Table'[MinDate]&&MAX('Item'[forecast start date])<='Table'[MaxDate],1,0)+IF(MAX('Item'[forecast finish date])>='Table'[MinDate]&&MAX('Item'[forecast finish date])<='Table'[MaxDate],1,0)+IF(MAX('Item'[actual start date])>='Table'[MinDate]&&MAX('Item'[actual start date])<='Table'[MaxDate],1,0)+IF(MAX('Item'[autual finish date])>='Table'[MinDate]&&MAX('Item'[autual finish date])<='Table'[MaxDate],1,0)

Then add this measure to your visual filter

 

Regards,

Charlie Liao

salimgs's avatar
salimgs
Frequent Visitor
9 years ago

Hi Charlie,

 

Thanks a lot for your detailed answer. Your solution works but I noticed my solution also works if I use IF(A,1,0)+IF(B,1,0) instead of A || B. Please see attached. If we define a Boolean measure, the visual level filter does not comprehend that. Get the file from here: https://ufile.io/dl5bz

 

  • salimgs's avatar
    salimgs
    Frequent Visitor
    9 years ago

    Is this a bug? How we should report it?