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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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