Forum Discussion
Create a filtered calculated table based on slicer value
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
Hi Rajendra,
Thanks for your help!
I have used followed the instructions as directed, but i am getting the following error.
A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table filter expression. This is not allowed.
The dax i am using is as follows:
Thanks