Forum Discussion

shtak's avatar
shtak
Helper II
2 years ago
Solved

Formula in a Matrix

Hi all,   I have a matrix with product and its category as rows and sales, volume and unit price as columns. we have a difficulty in showing the unit price when drill up/down as the following pict...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    2 years ago

    Hi,

    Please check the below picture and the attached pbix file.

     

     

     

    Sales measure: = 
SUM( sales[sales] )

     

    Volume measure: = 
SUM( sales[volume] )

     

    Unit price measure: = 
DIVIDE( [Sales measure:], [Volume measure:] )

     

shtak's avatar
shtak
Helper II
2 years ago

Hi Jihwan,

 

Thanks for your elaborate reply.

We succeeded based on your advice.

 

Regards,

Shinya