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