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
Gchandrukris's avatar
Gchandrukris
Helper I
6 years ago

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

v-kelly-msft's avatar
v-kelly-msft
Community Support
6 years ago

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!