Forum Discussion

Shawn3001's avatar
Shawn3001
Frequent Visitor
5 years ago

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...
Need Help
littlemojopuppy's avatar
littlemojopuppy
Community Champion
5 years ago

So I'm more than a little confused...you said in your original post "what I'm trying to do is create a measure(s) I can use to filter a table visual for records that meet criteria for frequency and duration (based on my report-level parameters)".  The severity measure I provided accomplishes exactly that.

 

Your "what I'm really looking for..." seems to be around presentation or perhaps you have a whole other idea for implementation?

Shawn3001's avatar
Shawn3001
Frequent Visitor
5 years ago

Sorry this is a little diffcult to explain without just being able to share my PBIX.

 

I was not able to download your PBIX so I wasn't able to see everything.  How do you calculate the number of occurences of a unique [Description]? The [Delay Count] in your Severity DAX is just a column of the what-if parameter values, correct?