Norm that is an average of a calculation

[Anonymous]

Hi guys,

I want to create a new measure that displays the norm of the items scant per hour. Since i have multiple process I want that the norm changes when i selected new processes. The norm should change based on how many item is scanned in a process. 

Items scanned	Norm (items per hour)	Process number
1000	50	A
500	100	B
600	60	C

Now i want to have a measure that displays a norm of 50 when i select process A. When i select norm B i want that it shows 100. But when i select A & B together i don't want to have a norm of 75 (avg of 50 & 100), but i want that the card/measure displays: 1000/1500 * 50 + 500/1500*100 = 66.67. In this example you can make a manual calculation but i have a total of almost 80 process that i want to have in one dashboard.

Is there anyone (or any datanaut) that can help me?

[mwegener · Accepted solution]

Hi @Anonymous 

try this Measure

Norm = 
    VAR SumItemScan = SUM('Table'[Items scanned])
RETURN
    SUMX('Table',DIVIDE('Table'[Items scanned],SumItemScan)*'Table'[Norm (items per hour)])

You may download my PBIX file from here.
Hope this helps.