Forum Discussion
Solved
Calc based on dynamic date slicer
Hi, I have data like the below table. Date Category Product Test_result 1/1/2021 A xyz Pass 1/1/2021 A pqr Fail 1/1/2021 B abc Fail ...
nidhishah , Please find attached file after signature.
Measure 3 is the one you are looking for.
Measure and measure2 you can use for validation
Also, @amitchandak the measure is not consiering a dynamic slicer at all. If i move the slicer to pick a date range that doesnt contain the max date in the main data set, then the measures aren't working.