help variable values

Laur1987 — Wed, 12 Apr 2023 13:25:41 GMT

Hi.

I have a project. A perfum store. The client wants to forecast the profits by the price of perfums. The price of perfums depends by the quantity of Ethanol and Perf Oil. How I can make that?

I made the calculator with slicer. (see attach) But I have to do the forecast now. Like in example below there is the production costs which included a static price of the perfume like R55.

So I need the price to be variable for this dashboard. When I change the price in the total bottle cost, to change the production cost. I tried with lookupvalue because I don t have relationship but is not working.

Thanks in advance.

amitchandak lbendlin Greg_Deckler Ashish_Mathur

topic help variable values in DAX Commands and Tips

help variable values