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