Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I have following measure based on field parameter
% of Duration Minutes by VIN =
DIVIDE(
CALCULATE(
SUM(combine_data_column[Duration_minutes])),
CALCULATE(
SUM(combine_data_column[Duration_minutes]),
SWITCH(
TRUE(),
--SELECTEDVALUE('Column Parameter'[Column Parameter - 2]) = "AUTO_STEERING_STATUS_BIN", NOT ISBLANK('combine_data_column'[AUTO_STEERING_STATUS_BIN]),
SELECTEDVALUE('Column Parameter'[Column Parameter - 2]) = "BAROMETRIC_PRESSURE_BIN (kPa)", NOT ISBLANK('combine_data_column'[BAROMETRIC_PRESSURE_BIN]),
SELECTEDVALUE('Column Parameter'[Column Parameter - 2]) = "BATTERY_VOLTAGE_BIN (V)", NOT ISBLANK('combine_data_column'[BATTERY_VOLTAGE_BIN])
)
which I'm displaying as a barchart
Now I would like to add 5 and 95 percentile whiskers as so
I'm trying to wrap me measure in percentile calculation but I get no results or errors
% of Duration Minutes by VIN - 5 Percentile =
PERCENTILEX.INC(
ALLSELECTED(combine_data_column[BATTERY_VOLTAGE_BIN]),
DIVIDE(
CALCULATE(
SUM(combine_data_column[Duration_minutes])),
CALCULATE(
SUM(combine_data_column[Duration_minutes]),
SWITCH(
TRUE(),
--SELECTEDVALUE('Column Parameter'[Column Parameter - 2]) = "AUTO_STEERING_STATUS_BIN", NOT ISBLANK('combine_data_column'[AUTO_STEERING_STATUS_BIN]),
SELECTEDVALUE('Column Parameter'[Column Parameter - 2]) = "BAROMETRIC_PRESSURE_BIN (kPa)", NOT ISBLANK('combine_data_column'[BAROMETRIC_PRESSURE_BIN]),
SELECTEDVALUE('Column Parameter'[Column Parameter - 2]) = "BATTERY_VOLTAGE_BIN (V)", NOT ISBLANK('combine_data_column'[BATTERY_VOLTAGE_BIN])
),
0.5
)
What am I doing wrong?
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
25 | |
20 | |
18 | |
18 | |
15 |
User | Count |
---|---|
38 | |
20 | |
19 | |
16 | |
10 |