Forum Discussion
Create a filtered calculated table based on slicer value
Hello, I am trying to create a calculated table based on a data table loaded in power bi. Can someone please help me fix the below dax, I am trying to replace the hard coded "ABC", with a dyn...
Hi anwarbi - it is possible, can you please create a seperate table for the slicer values
SlicerTable = DISTINCT('Table3'[name])
Now lets create a measure to filter your data dynamically based on the slicer selection using selectedvalue function
SelectedName =
SELECTEDVALUE(SlicerTable[name])
Since calculated tables can't use slicer values directly, you'll instead use a table visual in the report
FilteredTableMeasure =
CALCULATETABLE(
SUMMARIZE(
'Table3',
'Table3'[name],
'Table3'[Country],
'Table3'[companies],
'Table3'[Group]
),
'Table3'[name] = [SelectedName]
)
Hope this works. please check