Forum Discussion
Want the 'what if' parameter selection hard coded dynamically for each column of my calculated table
Hi all,
I want my 'what if' parameter selection hard coded dynamically for each column of my calculated table.
For Eg see below
Requirement 1
I have amount column in my table and I want that whatever value i select on my what if parameter, it goes and sits in each row of the percent column.
Requirement 2
This table below should be a new DAX table that uses addcolumns or selectedcolumns calculation.
| Amount | Percent |
| 10 | 30% |
| 20 | 30% |
| 30 | 30% |
| 40 | 30% |
| 50 | 30% |
After this I want to perform some calculations using amount and percent but this would happen only when I acheive the above.
2 Replies
klehar , You can not use what if column calculation. Actually, you can not use slicer in a calculated column calculation
You can use it only in measure
For static value
new column = .3 //mark as 5 column it will be 30 %
amitchandak I know I cant use measures in calculated columns.
But i'm looking for workarounds
