Forum Discussion

juliausha's avatar
juliausha
Helper I
8 years ago
Solved

Divide one column by another with a filter

Hi!  Does anyone know how to divide one suummarized column by another with a certiain text filter?    My example:    I created a matrix for different types of fruits. There's an Action (which is...
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    juliausha

     

    Try with following

     

    Measure =
DIVIDE (
    CALCULATE ( SUM ( Table1[Amount] ), Table1[Action] = "Eaten" ),
    CALCULATE ( SUM ( Table1[Amount] ), Table1[Action] = "Purchased" )
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

juliausha

 

Try with following

 

Measure =
DIVIDE (
    CALCULATE ( SUM ( Table1[Amount] ), Table1[Action] = "Eaten" ),
    CALCULATE ( SUM ( Table1[Amount] ), Table1[Action] = "Purchased" )
)