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 |
@Gchandrukris , you can also break down your mesures into small little components this way:
Profits = SUM('Table'[Profit])
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
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!!
Thanks for your response. Is there any other way other than creating measures. Because Deciles are dynamic. it keeps increasing.
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?
User | Count |
---|---|
125 | |
64 | |
56 | |
48 | |
41 |
User | Count |
---|---|
116 | |
67 | |
62 | |
62 | |
44 |