Percentile of a table stored in a variable
Hi all, I would like to detect outliers in my daily data report by using the percentile function. I have a detail table (table 1) and I want to calculate the percentile of the second table which shows the tickets per day. If I create a fixed calculated table I have to add "ALL / AllExcept" function inside Percentile function: Percentile = PERCENTILEX.EXC (ALL(TicketsByDate), TicketsByDate[Count_Tickets], .90 ) I need to apply external filters and I don't want to rely on the All/AllExcept function. For this reason, I want to store my calculated table in a variable. The problem is that I can't calculate the percentile of this calculated table in a variable. I get the following error: "If k is not a multiple of 1/(n + 1), PERCENTILEX.EXC will interpolate to determine the value at the k-th percentile." Can someone help me? Thanks!!!How to Filter PERCENTILE.EXC to Remove Top & Lowest 5 % using DAX
Hi Team, I created measure using the function PERCENTILE.EXC as show below. SalesPercentile90 = PERCENTILE.EXC(Query[SalesAmount],.09) However, how can I remove the Top 5% and Lowest 5% using the DAX. The picture below show sample of data Thank you in Advanced
