Forum Discussion

IF's avatar
IF
Post Prodigy
3 years ago
Solved

multiplication and sum

Hi,

I have a simple table below.  I am using a slicer to count Qty * price, when I select more than one value in the slicer. For example if I select AB and CD in the slicer menu, i want to see (10*50)+(20*30) which is 1100. How can i write a measure for this purpose?

SlicerQtyPrice
AB1050
CD2030
DF3040

 

Thanks in advance

Need Help
  • Jayee's avatar
    Jayee
    3 years ago

    Hi IF ,

     

    Try below measure

    Measure= sumx(table, Qty*Price)

     

    If this post helps, then please

     consider Accept it as the solution, Appreciate your Kudos!!

     

  • mariussve1's avatar
    mariussve1
    3 years ago

    Hi,

     

    Measure =
    Sumx ( table, table[qty] * table[price] )

     

     

     

    Br

    Marius

2 Replies

  • Jayee's avatar
    Jayee
    Responsive Resident
    3 years ago

    Hi IF ,

     

    Try below measure

    Measure= sumx(table, Qty*Price)

     

    If this post helps, then please

     consider Accept it as the solution, Appreciate your Kudos!!

     

  • mariussve1's avatar
    mariussve1
    Solution Sage
    3 years ago

    Hi,

     

    Measure =
    Sumx ( table, table[qty] * table[price] )

     

     

     

    Br

    Marius