Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Table Measure

Hi

there is a table i want to put progress of progress against plan.

= start plan / start actual

 

thanks for any help!

thanks,

Need Help

11 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    7 years ago

    Hi,

     

    Assuming Start Plan# and Start Actual# are measures, write this measure and format it as %.

     

    Progress=[Start Plan#]/[Start Actual#]

     

    Hope this helps.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      got the error message.

      the value start plan and actual are from different table. is that the reason i got the error?

      • d_gosbell's avatar
        d_gosbell
        Super User
        7 years ago

        This error probably means that "Start Plan#" and "Start Actual#" are just columns and Power BI is helpfully creating implied measures to aggregate these. So if you right click on one of the two tables and choose the "New Measure..." option then enter something like the following it should work:

         

        Progress = DIVIDE ( SUM( 'table1'[Start Plan#] ) , SUM ( 'table2'[Actual Plan# ) )

         

        Note: you'll need to replace 'table1' and ''table2' with the actual names of your 2 tables

         

        And I would have expected that you would want to do actual / plan so that you could say that you've reached x% of the plan...