Forum Discussion
prattja9
3 years agoFrequent Visitor
Create User Defined Bin Slicer with Parameter
I have some data that looks like this: Employee ID Age (years) 1 100 2 1 3 18 4 21 5 65 6 7 7 12 8 18 9 24 10 36 I am trying to create a histog...
- 3 years ago
Hi prattja9
With the new New Parameters menu, select Numeric Range. It works with the link you supplied. (pbix: 2 - Choose SIZE of Bins.pbix)
Let me know if you have any questions.
pbix: prattja9.pbix
- 3 years ago
Does this help? I changed to COUNTROWS( DimCustomer ) to
DISTINCTCOUNT( 'DimCustomer'[Employee ID] ) in the RETURN.Count of Customers in each Band - by size - 2 = VAR _minAge = [Min Age] VAR _maxAge = [Max Age] VAR _bandSize = [What is Band Size Value] VAR _AgeBandTable = GENERATESERIES( _minAge, _maxAge, _bandSize ) VAR _currAge = SELECTEDVALUE( 'Age Band'[Age] ) VAR _bandHead = MAXX( FILTER( _AgeBandTable, [Value] <= _currAge ), [Value] ) VAR _bandTail = _bandHead + _bandSize RETURN IF( _currAge = _bandHead, CALCULATE( DISTINCTCOUNT( 'DimCustomer'[Employee ID] ), 'Age Band'[Age] >= _bandHead && 'Age Band'[Age] < _bandTail ) )pbix: prattja9.pbix
prattja9
3 years agoFrequent Visitor
Got it to work using CALCULATE(DISTINCTCOUNT( instead of CALCULATE(COUTROWS(.
Thanks for your help!
grantsamborn
Solution Sage
3 years agoSorry. I didn't see this post until I posted.