Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Employee | Gross Pay | Percent Value |
1 | 1000 | |
2 | 1500 | |
3 | 2000 |
I have the above table in Power BI. I need the 'Percent Value' column to be populated with a value based on a parameter selection, i.e. If I input 80 (%) I want the following to appear:
Employee | Gross Pay | Percent Value |
1 | 1000 | 800 |
2 | 1500 | 1200 |
3 | 2000 | 1600 |
I cannot use a calculated column as the 'Percent Value' will need to change depending on the slicer (what if) selection. I don't know how to structure a measure as I cannot use the 'Gross Pay' value, it is loaded directly from an excel file and not available for use within a measure.
Any help greatly appreciated.
Solved! Go to Solution.
@Anonymous
You can not create a column You can create a measure
Percent Value = sum(Table[Gross Pay])*[what if measure]
//What will create a measure use that
@Anonymous
You can not create a column You can create a measure
Percent Value = sum(Table[Gross Pay])*[what if measure]
//What will create a measure use that
User | Count |
---|---|
130 | |
108 | |
101 | |
67 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |