Forum Discussion
DAX Measure
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 ?
Hi Anonymous ,
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]
1 Reply
Hi Anonymous ,
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]