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
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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'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!