Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

How to create a custom SLICER?

Hello   I have two sets of criteria, e.g.: CriteriaSet1: Col1 = A || Col2 <> B && Col3 = C CriteriaSet2: Col1 = D || Col2 <> E && Col3 = F   I want to use these criteria to filter a table. I ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous , In case you need as in filter. 

calculate([measure], filter(Table,(Col1 = D || Col2 <> E && Col3 = F) && (Col1 = A || Col2 <> B && Col3 = C)))
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    amitchandak 

     

    Thanks, can you elaborate how do I use that? Also what is the [measure] you mention?