Forum Discussion

gianmarco's avatar
gianmarco
Helper IV
3 years ago

Advanced filter

Dear All, I can slice a table for the following row values: 0 1 2 3   What I want to achieve is a slicer where I can filter for the following options: 0 & 1, 0 & 2, 0 & 3.   In other words, you ...
Need Help
Ahmedx's avatar
Ahmedx
Super User
3 years ago

Is this what you are looking for?

total = 
VAR _Valueselect =VALUES('Table'[Value])
VAR _SUM =CALCULATE([sales],FILTER(ALL('Table'),'Table'[Value] in _Valueselect))
VAR _SUMSERO = CALCULATE([sales],FILTER(ALL('Table'),'Table'[Value]=0))
VAR _Rsults = IF({0} in _Valueselect,_SUM,_SUM+_SUMSERO)
RETURN
_Rsults