I want to transform this in the form as shown in the matrix:
This has 2 columns, at the end, which require some calculation.
My end goal:
I want to make a line chart for different versions on x-axis and Have 2 calculated columns on the y-axis for a trend.
Ca anybody help me on this?
I tried lots of DAX and YouTubing but couldn't find much.
Create the following Measures:
E1 = CALCULATE( SUM('YourTable'[Session Count]), 'YourTable'[Event Name] = "E1")
E2 = CALCULATE( SUM('YourTable'[Session Count]), 'YourTable'[Event Name] = "E2")
...
E6 = CALCULATE( SUM('YourTable'[Session Count]), 'YourTable'[Event Name] = "E6")
E Total = [E1] + [E2] + [E3] + [E4] + [E5] + [E6]
AN Rate = DIVIDE( [E2] + [E3] + [E4] + [E5], [E6] )
D Rate = DIVIDE( [E1], [E6] )
Build your Matrix, and use the above for your Values
.