Calculation

[Anonymous]

Hello,

I need help with Power Bi function.
So I have columnz with many numbers that are sometimes repeated.
Factor = columnx/columny
I want to calculate column that shows factor for specific number in columnz not for row.
 columnz for 213  (2+6+15)/(2+2+3) = 3,28

columnz	columnx	columny	Factor
213	2	2	3,28
213	6	2	3,28
213	15	3	3,28
214	20	4	3,5
214	8	4	3,5
215	4	2	2
216	18	9	2,36
216	8	2	2,36

I have the biggest problem to make caclucation for specific number from columnz. Do you know how to calculate it?
Thanks,
Aleks

[AntonioM · Accepted solution]

Hi @Anonymous ,

You could use this column

Factor = 
CALCULATE ( 
    DIVIDE (
        SUM ( 'Table'[Columnx] ),
        SUM ( 'Table'[Columny] )
    ),
    ALLEXCEPT (
        'Table',
        'Table'[Columnz] 
    )
)