Forum Discussion
Create a Range Slicer for multiple columns
- 2 years ago
output :
create 4 measures
att q1 measure , att q2 measure, att q3 measure, att q4 measure
all of them same code with one difference : the calculation
check below :
Q1 ATT
q1 att measure = var min_value = MIN(slicer[Value]) var max_value = MAX(slicer[Value]) var dataousrce = FILTER( ADDCOLUMNS( VALUES('Table'[Person]), "@x" ,CALCULATE(SUM('Table'[Q1 Att])) ) ,[@x] >= min_value && [@x] <= max_value ) var res = CALCULATE( SUM('Table'[Q1 Att]), dataousrce ) return resQ2 ATT
Q2 att measure = var min_value = MIN(slicer[Value]) var max_value = MAX(slicer[Value]) var dataousrce = FILTER( ADDCOLUMNS( VALUES('Table'[Person]), "@x" ,CALCULATE(SUM('Table'[Q2 Att])) ) ,[@x] >= min_value && [@x] <= max_value ) var res = CALCULATE( SUM('Table'[Q2 Att]), dataousrce ) return resQ3 ATT
Q3 att measure = var min_value = MIN(slicer[Value]) var max_value = MAX(slicer[Value]) var dataousrce = FILTER( ADDCOLUMNS( VALUES('Table'[Person]), "@x" ,CALCULATE(SUM('Table'[Q3 Att])) ) ,[@x] >= min_value && [@x] <= max_value ) var res = CALCULATE( SUM('Table'[Q3 Att]), dataousrce ) return resATT Q4
Q4 att measure = var min_value = MIN(slicer[Value]) var max_value = MAX(slicer[Value]) var dataousrce = FILTER( ADDCOLUMNS( VALUES('Table'[Person]), "@x" ,CALCULATE(SUM('Table'[Q4 Att])) ) ,[@x] >= min_value && [@x] <= max_value ) var res = CALCULATE( SUM('Table'[Q4 Att]), dataousrce ) return resIf my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution !✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
Hi Greg_Deckler ,
Thank you for your reply!
If the range is selected between 1 to 10 in the slicer, I need all 4 columns to display the values that are between 1 to 20.
Thanks,
Poonam
output :
create 4 measures
att q1 measure , att q2 measure, att q3 measure, att q4 measure
all of them same code with one difference : the calculation
check below :
Q1 ATT
q1 att measure =
var min_value = MIN(slicer[Value])
var max_value = MAX(slicer[Value])
var dataousrce =
FILTER(
ADDCOLUMNS(
VALUES('Table'[Person]),
"@x" ,CALCULATE(SUM('Table'[Q1 Att]))
)
,[@x] >= min_value && [@x] <= max_value
)
var res =
CALCULATE(
SUM('Table'[Q1 Att]),
dataousrce
)
return res
Q2 ATT
Q2 att measure =
var min_value = MIN(slicer[Value])
var max_value = MAX(slicer[Value])
var dataousrce =
FILTER(
ADDCOLUMNS(
VALUES('Table'[Person]),
"@x" ,CALCULATE(SUM('Table'[Q2 Att]))
)
,[@x] >= min_value && [@x] <= max_value
)
var res =
CALCULATE(
SUM('Table'[Q2 Att]),
dataousrce
)
return res
Q3 ATT
Q3 att measure =
var min_value = MIN(slicer[Value])
var max_value = MAX(slicer[Value])
var dataousrce =
FILTER(
ADDCOLUMNS(
VALUES('Table'[Person]),
"@x" ,CALCULATE(SUM('Table'[Q3 Att]))
)
,[@x] >= min_value && [@x] <= max_value
)
var res =
CALCULATE(
SUM('Table'[Q3 Att]),
dataousrce
)
return res
ATT Q4
Q4 att measure =
var min_value = MIN(slicer[Value])
var max_value = MAX(slicer[Value])
var dataousrce =
FILTER(
ADDCOLUMNS(
VALUES('Table'[Person]),
"@x" ,CALCULATE(SUM('Table'[Q4 Att]))
)
,[@x] >= min_value && [@x] <= max_value
)
var res =
CALCULATE(
SUM('Table'[Q4 Att]),
dataousrce
)
return res
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution !✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠