Creating new measure that return value in percentage for each column

[Anonymous]

Hi,

I want to create the measure of sales profit that would return value in % for every column. Please find the snapshot below.

Measure=% Sales Profit = ( Actual Sales / (Sales ignored+Expected Sales) ) * 100.

[Fowmy]

@Anonymous 

What are scores? are they measures or rows in a table?
can you share the screenshot of the source data table?

[Anonymous]

Hi 

Please find the snapshot.

using Matrix Visualization, Now how to create the measure of % Sales_Profit

[Fowmy · Accepted solution]

@Anonymous 

Create the following measure :

% Sales Profit = 

var A = CALCULATE( SUM(Table8[Value]),Table8[Billing Scores] = "A = Actual Sales")
var C = CALCULATE( SUM(Table8[Value]),Table8[Billing Scores] = "C = Expected Sales")
var B = CALCULATE( SUM(Table8[Value]),Table8[Billing Scores] = "B = Sales ignored")
return
    DIVIDE(
        A,
        (B+C)
    )

[Anonymous]

Hi,

Getting below report with the measure

- As my requirement is to show the % sales profit above the column total value, not as below.

Required output as below.

- Below is the Visualization

[Anonymous]

Hi, Please find the below Matrix Visualization..

Need to add measure which is 

Measure=% Sales Profit = ( Actual Sales / (Sales ignored+Expected Sales) ) * 100.

need to show above the column "Total".