Forum Discussion
nbs33
Helper II
4 years agoFiltering Matrix Hierarchy by Parent's Measure Value
Hi, I've been stuck on this problem for a few weeks. You can find a sample of the data and the model here. I have a Orders, Companies, and Dates table. The Companies table has a Parent/Chil...
- 4 years ago
Try defining a new parameter that has values from 0% - 100% and create a measure to filter based on those parameter values in a slicer.
I defined a new table named Range and defined this as a filter measure.
InSelectedRange = VAR Level1Growth = CALCULATE ( [YTD vs PYTD Revenue %], ALLSELECTED (), VALUES ( Companies[Level 1] ) ) VAR RangeBuckets = FILTER ( Range, Range[Range] <= Level1Growth && ( Range[Range] = 1 || Range[Range] + 0.1 > Level1Growth ) ) RETURN IF ( ISEMPTY ( RangeBuckets ), 0, 1 )See attached file.
AlexisOlson
Super User
4 years agoI can't access the file you linked to.
nbs33
Helper II
4 years agoAlexisOlson sorry, put the wrong type of permision in google drive. It works now, just checked.