additional column in matrix

[Gchandrukris]

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	Product	Decile	Profit
1	p1	d01	100
2	p1	d01	200
3	p1	d02	300
4	p1	d02	400
5	p1	d03	500
11	p2	d01	1000
12	p2	d01	2000
13	p2	d02	3000
14	p2	d02	4000
15	p2	d03	5000
Expected
product	profit	do1	do2	do3
p1	1500	2	2	1
p2	15000	2	2	1

[ahmedoye]

@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]

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

[Anonymous]

Hello!!

First create this measures

Profit_M = sum(Hoja5[Profit])

d01 = CALCULATE(COUNT(Hoja5[Product]);Hoja5[Decile] = "d01")

d02 = CALCULATE(COUNT(Hoja5[Product]);Hoja5[Decile] = "d02")

d03 = CALCULATE(COUNT(Hoja5[Product]);Hoja5[Decile] = "d03")

Finally, put all together in a matrix.

Regards!!

[Gchandrukris]

Thanks for your response. Is there any other way other than creating measures. Because Deciles are dynamic. it keeps increasing.

[v-kelly-msft]

Hi @Gchandrukris ,

Create a new table,set"profit","d01","d2","d03" as the row value of the column:

Then create a measure as below:

Measure = 
SWITCH(SELECTEDVALUE('Table (2)'[Column]),"profit",SUM('Table'[Profit]),"do1",CALCULATE(COUNT('Table'[Product]),'Table'[Decile]= "d01"),"do2",CALCULATE(COUNT('Table'[Product]),'Table'[Decile]= "d02"),
"do3",CALCULATE(COUNT('Table'[Product]),'Table'[Decile]= "d03"),BLANK())

Finally you will see:

For the related .pbix file, pls click here.

In my suggestion,only one measure is needed ,I'm not sure whether it is what you need?

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!