Dynamic variation

[SpartakO1]

Hello everyone,

I trying to simplify the calculations for the following data:

need to calculate the variation between the different simulation, just to prevent creating measures each time we create a new simulation.  

How can I get a way to dynamically choose a simulation to compare with another one?

thank you!

Total Sale	Total Amount	Price per unit	Margin	Variant of simulation
4800	1200	8.0	44%	Rev1
4869	1345	8.1	46%	Rev2
6800	1789	7.6	42%	Rev3
4894	8923	9.3	54%	Rev4

[Anonymous · Accepted solution]

Hi  @SpartakO1  ,

Here are the steps you can follow：

You can use the selectvalue function to calculate the field data corresponding to the two data when you select two data in the variant of simulation

For example:

Select Rev1 and rev2, and compare the price per unit corresponding to Rev1 with the price per unit corresponding to rev2

1. Create measure

compara =
var _min=MIN('Table (2)'[Variant of simulation])
var _max=MAX('Table (2)'[Variant of simulation])
return
CALCULATE(SUM('Table (2)'[Price per unit]),FILTER(ALL('Table (2)'),'Table (2)'[Variant of simulation]=_max))
-
CALCULATE(SUM('Table (2)'[Price per unit]),FILTER(ALL('Table (2)'),'Table (2)'[Variant of simulation]=_min))

2. Result

You can downloaded PBIX file from here.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[SpartakO1]

thank you for your time, let me explain better the problem, i have to compare Rev1 with Rev2 or Rev3 and vice versa.

I'm not sure if parameters can help in this specific case

[aj1973]

Hi @SpartakO1 

In my understanding you need to use parameters feature of power BI

https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/

https://www.youtube.com/watch/iiNDq2VrZPY