Using PERCENTILE.INC inside CALCULATE/FILTER returning nothing

[Anonymous]

Hello! I am building a dashboard which trims outlier data from a year's worth of hourly data. I am using PERCENTILE.INC to replicate Excel's TRIMMEAN, filtering the bottom and top 10th percentile and creating a new average.

If I enter static values into my DAX measure, it works, but if I refer to my PERCENTILE.INC measures, it gives me nothing. Examples below.

I read the below article stating that the function just doesn't work inside CALCULATE, and I should consider creating a variable. I don't know much about variables yet, so unsure if this is the best solution or how best to approach it. Any help appreciated, I want to keep my measure dynamic to changes to the values of these PERCENTILE measures.

https://community.powerbi.com/t5/Desktop/PERCENTILE-inside-CALCULATE-does-not-anymore-recognise-data...

[Fowmy · Accepted solution]

@Anonymous 


Please check this measure, enter the correct table, and measure 

Trimmed funnel average conversion = 

VAR 10PC = [10TH PERCENTILE VISIT CONVERSION]
VAR 90PC = [90TH PERCENTILE VISIT CONVERSION]

RETURN
CALCULATE ( 
	[AVERAGE FUNNEL MEAURE]
FILTER ( 
	FLOSE_METRICS,
	[FUNNEL VISIT CONVERSION] > 10PC &&
	[FUNNEL VISIT CONVERSION] < 90PC
)

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[Anonymous]

@Fowmy thanks! Seems simple now.