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

    • 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# ) ))