Calculating value based on another value in same visual

[sreekanths]

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 data when all values are selected in sub category slicer is 

Data	Total Count	Actual value	Projected value
A	100	55	60
B	100	55	60

On choosing values from the sub category slicer, the table has to changes as below. The "A" row remains unchanged, but "B" row value changes.

Data	Total Count	Actual value	Projected value
A	100	55	60
B	95	45	43

The values in Data column is obtained from a disconnected table.

[amitchandak]

@sreekanths , We need more information on data. Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[sreekanths]

Input data

product	Project value	Actual value	sub category	Count
1	12	15	x	20
2	13	12	x	20
3	12	5	y	20
4	11	5	y	20
5	12	18	z	20

Data

A

B

Default view on pbix - no selection on sub-categories filter

Data	Total Count	Actual value	Projected value
A	100	55	60
B	100	55	60

Expected output on choosing Sub Category values x and z

Data	Total Count	Actual value	Projected value
A	100	55	60
B	100	45	43

[v-easonf-msft · Accepted solution]

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]

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]

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.