Forum Discussion
Creating a Measure To Return Summarized Values Based on Report Parameters/Slicers
Ok that makes more sense.
Now how would you create a table visual to return each individual Record ID (and associated details) that would qualify as Severe? When I use the DISTINCTCOUNT function within the measure/table, it shows a 1 for every row entry so I can't filter to only show the most common Descriptions.
Your definition of severe is "a "Severe" delay would be one that exceeds a specific Duration value AND occurs greater than n number of times per (in this case) year" which implies groups of individual delays determine severity. Individual delays will never be severe because they're individuals.
Unless you mean that an individual delay by itself would be severe if it exceeded a certain duration. In that case, in the severity measure I provided remove the AND function and the condition of DelayCount > 'Delay Count'[Delay Count Value].
