Forum Discussion

Gchandrukris's avatar
Gchandrukris
Helper I
6 years ago

additional column in matrix

Hi  I am new to powerbi , I wanted to add additional column(Profit) in the matrix . Please refer the table below.   Can the expected below is possible in Matrix ?   Table    Customeid Prod...
Need Help
ahmedoye's avatar
ahmedoye
Responsive Resident
6 years ago

Gchandrukris , you can also break down your mesures into small little components this way:


Profits = SUM('Table'[Profit])

Decile Count = COUNT('Table'[Decile])
d0 1 = CALCULATE([Decile Count],'Table'[Decile] = "d01")
d0 2 = CALCULATE([Decile Count],'Table'[Decile] = "d02")
d0 3 = CALCULATE([Decile Count],'Table'[Decile] = "d03")
 
You can then add Product Field and the Measures Profits, d01, d02 and d03 to your Matrix.

If this solution works for you, kindly kudo my response and mark as solution to allow others benefit from it.
 
 

 

  • Gchandrukris's avatar
    Gchandrukris
    Helper I
    6 years ago

    Hi,

    As you mentioned, I have created a separate measures for each column which works fine.

     

    In my case my measures calculates sales / sum(sales) for all columns. I wanted to show in the tooltip sales & totalsales.

     

    eg

    category  Measure1  Measure2 Measure3

    A              10             20             30

    B              20             30             30

     

    after calculating the percentage

    category  Measure1  Measure2 Measure3

    A             17 %           33%          50%

    B              25%            37.5%          37.5%

     

     

    In my tool on 17% I wanted to show s

    Sales: 10

    TotalSales : 60

     

    can you help me on this