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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.