Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Darius_108
New Member

Percentile of field parameter

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 

Darius_108_1-1688058581699.png

 

 

Now I would like to add 5 and 95 percentile whiskers as so 


Darius_108_2-1688058625931.png

 

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? 

0 REPLIES 0

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.