Forum Discussion
Solved
Dynamic column calculation based on user selection
Hi All, I would like to know if we can dynamically calculate column values in powerbi based on user selection For example, If user selects 1 from the selection filter, then my Result column ...
Hi, Kavitha10
Please check the below picture and the measure.
The sample pbix file's link is down below.
Result =SUMX('Table', 'Table'[COL_A] * SELECTEDVALUE('Switch'[Switch],1))Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Hi, Kavitha10
Please check the below picture and the measure.
The sample pbix file's link is down below.
Result =
SUMX('Table', 'Table'[COL_A] * SELECTEDVALUE('Switch'[Switch],1))
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Awesome, it worked! Thanks much.
