topic Re: How do I write a filter like this (Filter A = "b" or Filter B = "b") and Filter C = "x" in Report Server

How do I write a filter like this (Filter A = "b" or Filter B = "b") and Filter C = "x"

Anonymous — Mon, 16 May 2022 15:47:41 GMT

Trying to figure out in DAX how I can write this filter.

THANK YOU!

(Filter A = "b" or Filter B = "b") and Filter C = "x"

Re: How do I write a filter like this (Filter A = "b" or Filter B = "b") and Filter C = "x"

HenriqueReis — Mon, 16 May 2022 18:55:35 GMT

Hi, how are u?

Is that what you mean? A lot of customized filters for a report? Look:

If you want to do it, you just need to add a visual named 'slicer' and select a column with the informations you want to segregate, for exemple:

In this image, first I selected the visual 'slicer' (black circle), then I drag to there the column I want to use (red circle) and then I got the filter (blue circle).

I hope its help

Regards from BR!

Re: How do I write a filter like this (Filter A = "b" or Filter B = "b") and Filter C = "x"

Anonymous — Mon, 16 May 2022 18:57:24 GMT

Apologies this is a filter for a DAX calucation.

Re: How do I write a filter like this (Filter A = "b" or Filter B = "b") and Filter C = "x"

Icey — Thu, 19 May 2022 02:35:49 GMT

Hi Anonymous ,

If you want to calculate something like total sales, try this:

Measure = CALCULATE ( SUM ( 'YourTable'[Sales] ), A = "b" || B = "b", C = "x" )

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.