How to calculate percentage of two items in the same row in a Matrix

[chillpill]

I have an existing matrix with the below summed values. I would like to convert reach row value into a percentage of the total between the two row values. So in this case for January, the total is 6698 for <24H and > 24H (5716 + 982), which makes the <24H column 85% of the total between the two, and >24H at 15%.

I am looking for a way to get the matrix reflect like this instead:

CSC Email	<24H	>24H
January	85%	15%
February	73%	27%

[Ashish_Mathur]

Hi,

The solution would depend upon the layout of the original dataset.  Share the download link of the PBI file.

[Syk]

Create 2 measures. One like below, the other just flip the values 1 and 2!

Measure = Divide(sum('Table'[val1]),(sum('Table'[val1])+SUM('Table'[val2])),0)