Forum Discussion
Creating a Measure To Return Summarized Values Based on Report Parameters/Slicers
Thanks for the response! However, I don't think this is quite what I'm looking for.
I'm looking for the count of [ID] by [Description], not necessarily by [Asset]. I need to preserve slicer selection for an Asset but what I really am looking for is how often each specific [Description] code is used. This is where I tried to use the SUMMARIZE function to create a table like so:
Then, theoretically, I could filter this sumamrized table to only values that are greater than my What-If parameter, then use the CONTAINS (or something similar) to evaluate row-by-row whether an entry would be categorized as "Severe" (see below). I could never seem to get the correct return from that DAX though.
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?
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?