Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

August Carousel

Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.