Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
15 | |
11 | |
8 | |
8 | |
8 |
User | Count |
---|---|
22 | |
13 | |
11 | |
10 | |
10 |