Forum Discussion

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

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

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    5 years ago

    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.