Forum Discussion
Calculating value based on another value in same visual
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.
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 - v-easonf-msft
Community Support
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.
