Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
This post has closed.
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.
Please provide sample data in usable format (not as a picture).