DAX Measure

[sms2000]

Hi,

I have an Excel data 

Matrix	JAN	FEB	MAR	ARP	MAY	JUN	JUL	AUG	SEPT	OCT	NOV	DEC	TOTAL
Air	7	3	0	1	4	22	0	3.6	0	0	0	1	41.6
Water	2	6	1	0	0	5	0	2.1	3	0	0	0	19.1

i wanted to have a sciler for "qyt" between the range 1-50 , and upon selecting the value in the slicer, the value in the respective month changes by multipling with it. 

Example: if qyt = 2 ,  Air for JAN is 2*7 =  14 

how can i formulate this ?

[MFelix · Accepted solution]

Hi @sms2000 ,

Create a what if parameter and then use the metric that is created to make the multiplication.

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-what-if

The new measure will be something similar to:

Adjusted Qty = SUM(Qyt) * [Parameter measure]