Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Store values of a Measure and use them for Filtering data

Hi, I have a situation where there are readings stored in one table for various equipment that include time of reading and also the Start and End times when the person took the various readings (lets...
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi  Anonymous ,

    The calculation table cannot be used, and the calculation table cannot be affected by the slicer

    According to your description, I create this data:


    Here are the steps you can follow：

    1. Create measure.

    Measure =
var _start=SELECTEDVALUE('Table'[start time])
var _end=SELECTEDVALUE('Table'[end time])
return
IF(MAX('Table2'[filming time])>=_start&&MAX('Table2'[filming time])<=_end,1,0)

    2. Place the measure in the Filter, is=1, Apply filter.

    3. Result:

    You can downloaded PBIX file from here.

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Liu, many thanks for taking time to work on this example. I will try this soon and late you know.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous The solution you provided worked for me. There are two drill-through pages where I am navigating. One of them worked fine, the other one is coming empty even when there are photos taken during the time range. I will redo the drill-through filters on it and also recheck the measure I have set-up to ensure there are no mistakes. Thanks a lot for your help.