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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
zalalu
Frequent Visitor

Need urgent help!

This post has closed.

2 REPLIES 2
v-jingzhang
Community Support
Community Support

Hi @zalalu 

 

Try creating a measure instead of a calculated column. 

 

Target Output (MTD) = SELECTEDVALUE(Fact_Yield_Summary[Target output per day])  *  [Number of days_summary]

 

Measures are evaluated dynamically according to the context it locates in while calculated columns are initialized when they are created. If a measure is used in codes of a calculated column, it cannot pick any filter from the report. You can create a calculated column like columnname = [Number of days_summary] into the table to test whether it gets the same result as in the table visual (say 71).

 

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.

lbendlin
Super User
Super User

Please provide sample data in usable format (not as a picture).

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Kudoed Authors