Need urgent help!

[Anonymous]

This post has closed.

[v-jingzhang]

Hi @Anonymous 

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]

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