My data model has one table, Tbl
. It has a few fields including F1
.
On my page, there is a slicer (filter) on F1
. I want to build a measure that returns the filtered value for F1
and add it to a table visual.
The visual would look as such:
F1 (all values) | F1 (filtered value)
How can I do this?
This is a bit tricky since you want the slicer to affect one column but not the other.
What I would do is create a new table to use in a slicer.
Modeling > New Table: Slicer = VALUES(Table1[F1])
Then use Slicer[F1]
for you slicer instead of Table1[Slicer]
and define a measure
Selected F1 = MAX(Slicer[F1])
(You can use a different function like LASTNONBLANK
or SELECTEDVALUE
instead of MAX
if you prefer.)
Then if you set up your table with Table1[F1]
and [Selected F1]
, it should look like this: