SELECTEDMEASURE should filter the table
Hello. I have 2 measures, [Trained] and [Not Trained] for each active employee in a selected year(from a slicer) If I select the 4 on the left which stands for not trained, I want the table to show only the rows where [Is Trained] = 0 If I selected trained, the table should show the values where [Is Trained] = 1 However, that does not affect the table at all. I want the table to be dynamically filtered based on my slicer selection. I tried functions such as SELECTEDMEASURE( ), SELECTEDMEASURENAME( ), ISSELECTEDMEASURE( ), SELECTEDMEASUREFORMATSTRING( ) but neither of those worked. I added this other measure in order to filter for TRUE values but it didn't work. I would appretiate your help/suggestions. Thank you.
