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 AdvancedCalculate percentiles of a set of means?
We have a dataset of managers with employees under each manager. For each employee we need to calculate their mean performance for a particular measure. Then we need to rank each manager's employees to find a 25th percentile and mean performance value of this measure for each manager. How would we do this in DAX for power bi report server? Many thanks in advance for any tips.
