Hi all,
I created a table with a single column, to feed a Chiclet Slicer, and then a measure based on the selected value:
Selecionado = SELECTEDVALUE('Gerências'[Gerência],BLANK())
Said measure works fine, which I checked by adding it to a card, as seen:
However, when i try using it to calculate a column in another table, the value retrieved is blank, even if I simplify the formula to:
Column = [Selecionado]
Any clue on what may be causing it?
Solved! Go to Solution.
Calculated columns cannot read slicer values. They are only calculated when your data initially loads (or after refreshing it), not in response to your slicers and filters.
Calculated columns cannot read slicer values. They are only calculated when your data initially loads (or after refreshing it), not in response to your slicers and filters.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
125 | |
78 | |
69 | |
55 | |
55 |
User | Count |
---|---|
200 | |
104 | |
85 | |
80 | |
77 |