Forum Discussion
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...
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.
amitchandak
Super User
Super Usersreekanths , 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.
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 |