Measure from row values

[olijo]

Hello! I have a table like this:

dim1     dim2     value1
b1             A              4
b1             B             20
b2             A             5
b2             B            30
b3             A             2
b3             B              6
b4             A              1
b4             B              40
b5              A             20
b5              B           200

and a measure like this: measure:=sum(value1).

How can I make in Power BI table like this:

where values in column C = A/B in percents.

How can I make this in Power BI, when I have only one measure for each row and I need to mix two rows (A and B)? Thanks in advance!

[Anonymous · Accepted solution]

@olijo Please create below measure to get the desired result

A = CALCULATE(SUM('Table'[value]),'Table'[dim2]="A")
B = CALCULATE(SUM('Table'[value]),'Table'[dim2]="B")
C = DIVIDE([A],[B],0)