Different calculations based on selection

[finch]

Hello, could you please advise me how to perform below calculation?

I want to select particular value from "Grupa" table and show "Zmienna" in table on the left. 
In below example it would be 0 for all rows and 1.11 for "Wyjazd". 

Then I will perform multiplication of this "Zmienna" and value shown by measure in this table, but it should be easy if I overcome above issue.

Paweł  

[Anonymous · Accepted solution]

Hi @finch ,

Please follow steps below.

1. Create a table for slicer:

Grupa(for slicer) = VALUES('Table'[Grupa]) 

2. Add a what-if parameter:

3. Create a measure:

Measure = IF(MAX('Table'[Grupa])=SELECTEDVALUE('Grupa(for slicer)'[Grupa]),[Parameter Value],0)

Output:

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

[amitchandak]

@finch , based on the column name

if(selectedvalues([Grupa]) = max(Table[Grupa]), [Wyjazd measure], 0) +0