The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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.
@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