Forum Discussion

lailailaieric's avatar
lailailaieric
Regular Visitor
9 years ago

Data Representation

Dear All   I have started to use PowerBI and I ran into this problem. I have looked online but seems like there are no solutions to it just yet.     As per below, these are the information I have.   ...
Need Help
Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
9 years ago

Hi lailailaieric

 

Have you tried adding a calculated measure to your table?

 

Something like this?

 

Amount Per Staff = 
	DIVIDE(
		SUM(Table2[Amount]) , 
		SUM(Table2[Staff])
		)
lailailaieric's avatar
lailailaieric
Regular Visitor
9 years ago

Hi Phil

 

If thats the case, does it mean i have to use the table format again for this chart and I cant use other visuals?

 

Because the aim for me to when I click Asia, the number representating would appear, but when nothing is click "0.41" would show up. 

 

Thanks

 

 

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    9 years ago

    The measure should work as expected and show the correct number.

     

    Give it a try :)

    • lailailaieric's avatar
      lailailaieric
      Regular Visitor
      9 years ago

      Sorry Phil, 

       

      Do you mind showing it once to me, step by step how you can type in the formula?

       

      Because I am unable to locate the place to do so.

       

      Thank you so much for your help. 

       

      REally appreciating you helping me

      • Phil_Seamark's avatar
        Phil_Seamark
        Microsoft Employee
        9 years ago

        Hi lailailaieric

         

        Sure,  First of all make sure your table is highlighted,  Then from the modeling table, click the "New Measure" button

         

        Then 2) enter the forumla I posted above in step 2 ) but change the name of Table2 to be the same name as your table