Forum Discussion

finch's avatar
finch
New Member
4 years ago
Solved

Different calculations based on selection

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ł  

 

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    finch , based on the column name

     

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.