Search code examples
powerbipowerbi-desktop

Visualization from a master table


Here's my base table:
enter image description here

I want to transform this in the form as shown in the matrix:
enter image description here

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.


Solution

  • 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.