topic Re: SELECTEDMEASURE should filter the table in DAX Commands and Tips

SELECTEDMEASURE should filter the table

Anonymous — Fri, 23 Sep 2022 12:17:06 GMT

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.

Re: SELECTEDMEASURE should filter the table

amitchandak — Sat, 24 Sep 2022 02:34:18 GMT

Anonymous , use calculation group for that

https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0

Re: SELECTEDMEASURE should filter the table

Anonymous — Mon, 26 Sep 2022 06:48:51 GMT

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.

Re: SELECTEDMEASURE should filter the table

Anonymous — Mon, 26 Sep 2022 08:42:06 GMT

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