Forum Discussion

alisson_vilela's avatar
alisson_vilela
Frequent Visitor
5 years ago
Solved

Calculated column not recognizing measure value

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?

 

 

 

  • 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.

1 Reply

  • 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.