Forum Discussion

sreekanths's avatar
sreekanths
Regular Visitor
6 years ago
Solved

Calculating value based on another value in same visual

Hi, Is it possible to change the values in only selected rows in a table based on a slicer selection?   Values in Total Count, Acutal Value and Project Value are obtained from Measures.   My dat...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    6 years ago

    Hi , mahoneypat 

    Is the expected result you provided wrong?

    Is this your real expected result?

    Please check if the following measure helps.

     

    Compare_Total Actual value = 
SWITCH (
    TRUE (),
    SELECTEDVALUE ( 'Table 3'[Data] ) = "A", 'Table 1'[Total Actual_value],
    SELECTEDVALUE ( 'Table 3'[Data] ) = "B", 'Table 1'[S_Total Actual_value]
)

     

    .....

    Here is a sample pbix attached.

     

    Best Regards,
    Community Support Team _ Eason
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

mahoneypat's avatar
mahoneypat
Microsoft Employee
6 years ago

Not totally clear on what your goal is, but you can have row dependent logic with an approach like this

 

NewMeasure = if(selectedvalue(Table1[ColumnInVisual])=selectedvalue(DisconnectedTable[Value]), [MeasureForBRow], [MeasureForOtherRows])

 

If this works for you, please mark it as solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

  • sreekanths's avatar
    sreekanths
    Regular Visitor
    6 years ago

    Can you please explain which table you are referring to in your expression - NewMeasure = if(selectedvalue(Table1[ColumnInVisual])=selectedvalue(DisconnectedTable[Value]), [MeasureForBRow], [MeasureForOtherRows])

     

    I am getting Data from one table and all other values from another table.