topic Re: Using PERCENTILE.INC inside CALCULATE/FILTER returning nothing in DAX Commands and Tips

Using PERCENTILE.INC inside CALCULATE/FILTER returning nothing

Anonymous — Sun, 20 Sep 2020 13:59:57 GMT

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/m-p/49990

Re: Using PERCENTILE.INC inside CALCULATE/FILTER returning nothing

Fowmy — Sun, 20 Sep 2020 14:47:25 GMT

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

Re: Using PERCENTILE.INC inside CALCULATE/FILTER returning nothing

Anonymous — Sun, 20 Sep 2020 17:00:10 GMT

Fowmy thanks! Seems simple now.