Calculate percentage between columns of a matrix

[Anonymous]

Hi all,

I am looking for a way to calculate the percentage between 2 columns of a matrix, for example in the sample data/file, I would like to add 2 new colums, Column 1: %Not preferred = Not Preferred/Final &  Column 2: %Preferred = Preferred/Final which will include percentage for the total as well. I have also included a link to the sample data.pbix file (Sample Data.pbix ). 

Thank you in advance for all the help.

Sample pbix link -> Sample Data.pbix 

Thank you!!

[Ashish_Mathur · Accepted solution]

PBI file attached.

Hope this helps.

[Anonymous]

Thank you so much @Ritaf1983 & @Ashish_Mathur . Both solutions work like a charm.

[Ashish_Mathur]

You are welcome.

[Ritaf1983 · Accepted solution]

Hi @Anonymous 
You can use these measures :

Basic sum = sum('Table'[Value])

Final =

CALCULATE([Basic sum],Module[Metric]="final")

Not prefered =

CALCULATE([Basic sum],Module[Metric]="Not preferred")

Not preferred % = DIVIDE([Not prefered],[Final])

Preferred =

CALCULATE([Basic sum],Module[Metric]="preferred")

Preferred % = DIVIDE([Preferred],[Final])

Just drag them to the values of the matrix ("columns" should stay blank)

The pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Ashish_Mathur · Accepted solution]

PBI file attached.

Hope this helps.