Forum Discussion
Creating a Measure To Return Summarized Values Based on Report Parameters/Slicers
Sorry, I know this is not super straight forward and I'm probably a little too close to the subject to explain it properly.
Think about the [Description] column as the failure-mode for an asset. I'm not so concerned with low-frequency failure-modes (regardless of duration) because these are not the most detrimental to the asset and I'm not going to prioritize corrective actions to failure-modes that may only occur once or twice per year. I'd rather focus on repetitive, high-frequency failure-modes and events that also have a moderate downtime duration associated with them. This is why I'm looking to return a table of records containing [Description] values that occur frequently within my dataset and with high duration (according to those what-if parameters). So ultimately, I need to look individually at Downtime Duration and holistically at Downtime Description.
Does that a do a better job of explaining the purpose?