Data Representation

Question

Dear All &nbsp; 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. &nbsp; &nbsp; As per below, these are the information I have.&nbsp; &nbsp;&nbsp;Place &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Amount &nbsp; &nbsp; &nbsp; &nbsp;Staff &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Amount per Staff (Amount divided by Staff)East China &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 11 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0.91West China &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 30 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0.67South China &nbsp; &nbsp; &nbsp; &nbsp; 62 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 50 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1.24Asia &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;17 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 25 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0.68Total &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 109 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;263 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0.41 &nbsp; &nbsp;Does anyone how in PowerBI can I show the "0.41" as the answer? &nbsp; I am only able to get the average, sum, count, etc amount per staff but that is not what I am looking for. I am looking for the total amount divided by total staff.&nbsp; &nbsp;&nbsp;Looking forward to hear from you pros out there.&nbsp;

phil_seamark · Answer

Hi&nbsp;lailailaieric&nbsp;Have you tried adding a calculated measure to your table?&nbsp;Something like this?&nbsp;Amount Per Staff = 
	DIVIDE(
		SUM(Table2[Amount]) , 
		SUM(Table2[Staff])
		)

lailailaieric · Answer

Hi Phil&nbsp;If thats the case, does it mean i have to use the table format again for this chart and I cant use other visuals?&nbsp;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.&nbsp;&nbsp;Thanks&nbsp;&nbsp;

phil_seamark · Answer

The measure should work as expected and show the correct number.&nbsp;Give it a try :)

lailailaieric · Answer

Sorry Phil,&nbsp;&nbsp;Do you mind showing it once to me, step by step how you can type in the formula?&nbsp;Because I am unable to locate the place to do so.&nbsp;Thank you so much for your help.&nbsp;&nbsp;REally appreciating you helping me

phil_seamark · Answer

Hi&nbsp;lailailaieric&nbsp;Sure, &nbsp;First of all make sure your table is highlighted, &nbsp;Then from the modeling table, click the "New Measure" button&nbsp;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&nbsp;&nbsp;

Forum Discussion

Data Representation

9 Replies

Related content

Bradley Terry score representation - visuels?

Better visual representation

graphic representation

Fabric & Azure Data User Group Program Requirements & Benefits

Dashed Line Representation for Future Dates