multiplication and sum

[IF]

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?

Slicer	Qty	Price
AB	10	50
CD	20	30
DF	30	40

Thanks in advance

[Jayee · Accepted solution]

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 · Accepted solution]

Hi,

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

Br

Marius

[Jayee · Accepted solution]

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