Forum Discussion

ridercos's avatar
ridercos
Regular Visitor
9 years ago

Row percent based on row total in a matrix

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

1 Reply

  • Eric_Zhang's avatar
    Eric_Zhang
    Icon for Microsoft Employee rankMicrosoft Employee

    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]