Forum Discussion

Bendelyon's avatar
Bendelyon
Icon for Helper I rankHelper I
2 years ago
Solved

How to compare between severals values in a simple table

Hello,   I have a table with a colum with 3 différents values. Budget, R2 and realized ans another with sales numbers.   I need to compare the sales numbers values in termes of the three values R...
power bi
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi johnbasha33 

     

    Based on your needs, I have created the following table.

     

    Then you can create a field parameter.

    Put the created field parameters into the slicer.

     

    Create the following two measures to compare the difference between Budget, R2, and realized and put them into the card visual.

    Budget_realized = IF(SELECTEDVALUE(Parameter[Parameter Order])=0,SUM('Table'[Budget]) - SUM('Table'[realized]),BLANK())
    R2_realized = IF(SELECTEDVALUE(Parameter[Parameter Order])=1,SUM('Table'[R2]) - SUM('Table'[realized]),BLANK())

     

     

     

     

     

     

    Best Regards,

    Jayleny

     

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi johnbasha33 

 

Based on your needs, I have created the following table.

 

Then you can create a field parameter.

Put the created field parameters into the slicer.

 

Create the following two measures to compare the difference between Budget, R2, and realized and put them into the card visual.

Budget_realized = IF(SELECTEDVALUE(Parameter[Parameter Order])=0,SUM('Table'[Budget]) - SUM('Table'[realized]),BLANK())
R2_realized = IF(SELECTEDVALUE(Parameter[Parameter Order])=1,SUM('Table'[R2]) - SUM('Table'[realized]),BLANK())

 

 

 

 

 

 

Best Regards,

Jayleny

 

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