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
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...

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi, thanks!

     

    it worked!! but in this case (yellow highlight)

    i want to see 290% there..? is that possible?

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      7 years ago

      Hi,

       

      Try this

       

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi,

        Hi,

        it worked! thanks very much!

        one last question, can i put 0% or something in the other way?

        because i am thinking to colour them base on the perscontage in next step so feel like need to put some figure in it to remark.