Forum Discussion
Creating a Measure To Return Summarized Values Based on Report Parameters/Slicers
Hello, I'm working with a large data set of manufacturing asset downtime and I'm trying to filter the display of a report table based on the values of a couple of report-level parameters. Pictur...
Can you explain in plain English what severity means without referring to your DAX measure? This doesn't seem like it's very difficult but hard to figure out what you were trying to do with the Severity measure...
Yes of course.
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. Given the example above, those 4 delays would be qualified as "Severe" or "Catastrophic" because each instance exceeds the Duration threshold of 0.5 hours, and those specific Description codes ("Rice Krispies" & "Apple Jacks") appear more than n times within the whole dataset.
Hopefully that makes more sense!