Forum Discussion

Helper I

5 years ago

Solved

Filter or Slicer with OR

I would like to ask if there's any way to create a slicer or page/visual filter that allows us to use OR. For example, imagine I have a table with data from each phone call a business has had. They a...

Need Help

P_D_G
5 years ago
Hi antalgu ,

I think that you are looking for the feature called Calcultaion Groups.

Here is a great article which summarizes the logic & gives you an example how to use this:
https://www.sqlbi.com/articles/introducing-calculation-groups/#

edit:
Adding 2 videos which are useful too:
Guy in the Cube: https://www.youtube.com/watch?v=vlnx7QUVYME
Marco Russo from SQLBI: https://www.youtube.com/watch?v=a4zYT-N-zsU

Hope it helps,
PDG

antalgu

Helper I

5 years ago

Nono, the problem that I have is this one. The type of code that you presented would work to solve the problem, but it would only solve 1 of the measures, so I'd have to make this code for 10+ measures and then a pretty similar one for 10+ more measures for the other type of calls. What I'm asking is if its possible to do this kind of things with a page filter or slicer, because I don't want to have to modify the code individually for each one of my measures

P_D_G