Forum Discussion
Slicer & value pick
So I have say 3 columns,
(num)Col A (num)Col B (num)Col C (Calculated = Col A * Col B)
0.5 2 0.5 * 2
7 5 7 * 5
5 x 5*x
I want to pick a value for Col B using Slicer (variable value), and Col C should automatically the col B value accross the board! meaning entrie col C will use Col B variable value. Any idea how can I do this ?
Hi, Crazydog ;
May be you need add a new table from column2,
Table 2 = VALUES('Table'[Column2])Then you could create a measure,
column3 = SUM('Table'[Column1])*MAX('Table 2'[Column2])The final show:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- parry2k
Super User
Crazydog you need to add a measure with the following expression:
Measure C = VAR __colBValue = SELECTEDVALUE ( Table[Col B] ) RETURN SUMX ( Table, Table[Col A] * __colBValue )✨ Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.
v-yalanwu-msftCommunity Support
Hi, Crazydog ;
May be you need add a new table from column2,
Table 2 = VALUES('Table'[Column2])Then you could create a measure,
column3 = SUM('Table'[Column1])*MAX('Table 2'[Column2])The final show:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
