Forum Discussion

sachal_rana's avatar
sachal_rana
Frequent Visitor
8 years ago

Update values in table which are based on a measure

My table contains two columns; one is static text field, and the other column has values based on a calculated measure. If the value of the measure changes, the table does not update and hence the column chart does not update. 

What is a workaround of this? 

12 Replies

  • RMDNA's avatar
    RMDNA
    Icon for Solution Sage rankSolution Sage
    8 years ago

    sachal_rana,

     

    A measure changes in response to front-end changes to the table (by slicing, cross-filtering, etc.). How would you change the value of a measure directly?

    • sachal_rana's avatar
      sachal_rana
      Frequent Visitor
      8 years ago

      The value of the measure is being changed indirectly through a what-if measure. The measure is currently based off of a count which changes based on another measure that is being calculated using a what-if measure. 

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Hi sachal_rana

         

        Is it possible to share some sample data, measures and the outcome expected. Please put in google drive or one drive and share the link to explore solution.

         

        Cheers

         

        CheenuSing

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi sachal_rana,

        Please check this:

    • Column: table only load 1 time when Opening or Load data.
    • Measure: refresh when interaction (Clicer, click to forcus visualization,...)

       You can using a "New measure" instead of "New column". Send me your sample pbix file, I can fix on it and resend :)

     

    Regards,

    ManNVSM.