Row percent based on row total in a matrix

[ridercos]

Hi 

I need some help..

I have a table

Date(Bins)    Type A        Type B        Type C       RowTotal (I created this measure adding the row)

Jan 2016         30              276              342               648

Feb 2016         24             269              307               600

Mar 2016        41             332              286               659

I need to be able to add columns Type A % of RowTotal

Type B % of Row Total

Type C % of Row Total 

and display that in 3 columns for each of the months or rows like shown above

Anyhelp? Thanks in advance

[Eric_Zhang]

---

@ridercos wrote:

Hi 

I need some help..

I have a table

Date(Bins)    Type A        Type B        Type C       RowTotal (I created this measure adding the row)

Jan 2016         30              276              342               648

Feb 2016         24             269              307               600

Mar 2016        41             332              286               659

I need to be able to add columns Type A % of RowTotal

Type B % of Row Total

Type C % of Row Total 

and display that in 3 columns for each of the months or rows like shown above

---

If that is a table visual, I think you can create 3 measures as below. The [RowTotal] is the measure you already  created.

Type A % = SUM(yourTable[TypeA])/[RowTotal]