Forum Discussion
ALLSELECTED SUM only data filtered
- 2 years ago
you can set the filter on the page level in the filter pane .
that would work .
or ,
you need to select each value in the slicer, ( and not using the select all ) for it to work .
If this answers your question , mark it as the solution ✅ so can you can help other people in the community find it easily .
can you please try the following measure :
sumx (
values(tbl_name[col_name]) ,
CALCULATE(SUM('Table'[Value])
)
let me know if that works for you .
if this not what you are looking for, please share a screenshot of wthe desired output with sampl data .
If this answers your question , mark it as the solution ✅ so can you can help other people in the community find it easily .
- Daniel291952 years agoCommunity Champion
could you please share the file so i can take a look?
- Tevon7132 years agoHelper V
- Daniel291952 years agoCommunity Champion
you can set the filter on the page level in the filter pane .
that would work .
or ,
you need to select each value in the slicer, ( and not using the select all ) for it to work .
If this answers your question , mark it as the solution ✅ so can you can help other people in the community find it easily .