Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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 ...
SELECTEDMEASURENAME
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous ,

I have created a simple sample, please refer to it to see if it helps you.

Create a measure.

Measure =
VAR _selected =
    SELECTEDVALUE ( 'Table'[YES OR NO] )
RETURN
    IF ( _selected = "Not Trained", 0, IF ( _selected = "Trained", [is trained] ) )

If I have misunderstood your meaning, please provide your pbix file without privacy inforamtion .

 

Best Regards

Community Support Team _ Polly

 

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
    3 years ago

    This is not the exact scenario.

    I am sharing a sample file to illustrate my problem and hopefully resolve it with your help.

    I want to filter active employees based on my YEAR selection from a slicer. YEAR is a field on my date table named DATA TAB.
    Active employes should have started working before or on the year selected, and termination date should either be on the year selected or after that year, or blank if the employee is still working.

    After I manage to consider only active employees I thought to create a measure with trained employees in a selected year. I named the measure [Trained]
    Not trained is the difference from total employees to [trained] employees.

    I want the pie chart that shows distinct employees trained, and those not trained in a selected year, to filter the table as well.

    Suppose I want to see not trained employees and I want this to be filtered in the table from my pie chart selection.
    I hope I was clear.
    https://we.tl/t-D5ZK2kS3Rg 
    Here is the file vie wetransfer.

    Thank you