Forum Discussion

shtak's avatar
shtak
Icon for Helper II rankHelper 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:] )

     

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
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:] )