cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
alisson_vilela
Frequent Visitor

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:

alisson_vilela_0-1616617202545.png

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?

 

 

 

1 ACCEPTED SOLUTION
AlexisOlson
Super User
Super User

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.

View solution in original post

1 REPLY 1
AlexisOlson
Super User
Super User

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.

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

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!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors