In power bi we have tried to create a table using dax table expression with certain conditions.Inside the condition we use a value selected from the slicer (function user -SELECTEDVALUE())for evaluation ,when using this function to fetch the data we get an out put contain a table with only header.enter image description here
The above image shows the original dataset.From this dataset we tried to create dax table by filtering the values of the coloumn Industry_aggregation .The new table will contain only those values matching the slicer selection.enter image description here In the above image we have created a slicer,selected a value "Level 4".enter image description here In the above image is the output that we get while trying to create a table.Here we used the following code to create a table. FILTER('annual-enterprise-survey-2020-f','annual-enterprise-survey-2020-f'[Industry_aggregation_NZSIOC]=SELECTEDVALUES('annual-enterprise-survey-2020-f'[Industry_aggregation_NZSIOC])) but we are not getting the output that we require.
But when we replace changed FILTER('annual-enterprise-survey-2020-f','annual-enterprise-survey-2020-f'[Industry_aggregation_NZSIOC]=SELECTEDVALUES('annual-enterprise-survey-2020-f'[Industry_aggregation_NZSIOC])) to FILTER('annual-enterprise-survey-2020-f','annual-enterprise-survey-2020-f'[Industry_aggregation_NZSIOC]="Level 4") it is working but remains static. enter image description here
