Use of the OR condition between segmentations to filter a table

[Ivancito111]

Hello,

I have the following request:
I have 4 Segmentations, the first one filters by AA, the second BB, the third CC and the fourth DD.

All filters are from a column of the table I want to filter.
The problem is that when I filter the table with the segmentations a && is applied. For example, if I select AA "Yes" in the first segmentation and BB "No", I will have all the tasks with AA "YES" && BB "NO".
What I would like is that all tasks with AA "YES" || BB "NO". Without leaving aside the 4 segmentations, if I also want to filter by CC "NO", the table will be seen with AA "YES" || BB "NO" || CC "NO".

Illustration of my table:

Ilustration of my slicer:

Example segmentation:

In addition to that I would like that if I filter by only one also works since all the solutions I have found do not allow me to filter by only one task.

Any kind of information would be very helpful, and thank you for taking the time to read my problem.

Thanks in advance.
Regards.

[amitchandak]

@Ivancito111 , You need an independent slicer for that. Create independent table with Yes and No value

var _1 = selectedvalue(Table1[Value])

var _2 = selectedvalue(Table2[Value])

return

calculate(countrows(Table), Filter(Table, [AA] =_1 && [BB] =_2))

refer if needed

Need of an Independent Table in Power BI: https://youtu.be/lOEW-YUrAbE

[Ivancito111]

Dear I tried this idea and it does not meet my requirement, as I need multiple slicers to perform an OR condition. Not a standalone slicer, yes, it serves its purpose but it is not my requirement, thanks anyway.

Regards.

[v-kkf-msft]

Hi @Ivancito111 ,

Please create a table:

Slicer = 
CROSSJOIN(
    DISTINCT('Table'[AA]),
    DISTINCT('Table'[BB]),
    DISTINCT('Table'[CC]),
    DISTINCT('Table'[DD])
)

Then create measure and filter NAME column by Measure.

Measure = 
var tab = 
CALCULATETABLE(
    VALUES('Table'[NAME]), 
    FILTER(
        'Table', 
        'Table'[AA] = SELECTEDVALUE(Slicer[AA])
        || 'Table'[BB] = SELECTEDVALUE(Slicer[BB])  
        || 'Table'[CC] = SELECTEDVALUE(Slicer[CC])
        || 'Table'[DD] = SELECTEDVALUE('Slicer'[DD]) 
    )
)
return 
IF( 
    ISFILTERED(Slicer),
    COUNTROWS( 
        INTERSECT( VALUES('Table'[NAME]), tab ) 
    ),
    COUNTROWS( 
        INTERSECT( VALUES('Table'[NAME]), VALUES('Table'[NAME]) ) 
    )
)

Put the fields in table Slicer into the slicers separately and change the interaction between the slicers to "None".

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

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

[Ivancito111]

Hello friend, I really appreciate the time you took to help me and that's why I tried to answer you in the shortest time possible.
That said, let's move on to what matters, it didn't work for me, it still works as an AND (&&), although it works as OR ( || ) for you.

I will attach the necessary pictures so that you can understand what I did and how I did it, since I tried to upload the file but I did not understand how.

BD:

Slicer:

Measure:

Filter in table:

Results

This is how what you sent me worked for me, which would not fulfill the requirement I have been asked for. I look forward to your reply and thank you very much.

Regards,

[Ivancito111]

N°	Name	features	Price	Legs	AA	BB	CC	DD
1	Polar Bear	xxx	1000	4	YES	NO	YES	NO
2	Penguin	xxx	2000	8	YES	NO	YES	NO
3	Cow	xxx	3000	12	NO	YES	YES	NO
4	Deer	xxx	4000	16	NO	YES	NO	NO
5	Raccoon	xxx	5000	20	YES	YES	NO	YES
6	Whale	xxx	6000	24	YES	NO	NO	YES
7	Frog	xxx	7000	28	NO	NO	NO	YES
8	Seal	xxx	8000	32	NO	NO	YES	YES
9	Dromedary	xxx	9000	36	YES	YES	YES	YES
10	Horse	xxx	10000	40	YES	YES	YES	NO
11	Bull	xxx	11000	44	NO	YES	YES	NO
12	Frog	xxx	12000	48	NO	NO	NO	NO
13	Seal	xxx	13000	52	YES	NO	NO	NO
14	Dromedary	xxx	14000	56	YES	NO	NO	NO
15	Cow	xxx	15000	60	NO	YES	NO	YES
16	Deer	xxx	16000	64	NO	YES	YES	YES
17	Raccoon	xxx	17000	68	YES	YES	YES	YES
18	Seal	xxx	18000	72	YES	NO	YES	YES
19	Dromedary	xxx	19000	76	NO	NO	YES	YES
20	Cow	xxx	20000	80	NO	NO	NO	NO
21	Polar Bear	xxx	21000	84	YES	YES	NO	NO
22	Penguin	xxx	22000	88	YES	YES	NO	NO
23	Cow	xxx	23000	92	NO	YES	NO	NO
24	Whale	xxx	24000	96	NO	NO	YES	NO
25	Frog	xxx	25000	100	YES	NO	YES	YES
26	Seal	xxx	26000	104	YES	NO	YES	YES
27	Dromedary	xxx	27000	108	NO	YES	YES	YES
28	Horse	xxx	28000	112	NO	YES	NO	YES
29	Bull	xxx	29000	116	YES	YES	NO	YES

[Ivancito111]

After a lot of testing I realized that I did not take the values of the slicers correctly, I had taken AA from the table and not from the slicer.

But even so, now the error has intensified, because if I set AA "No" it shows me values with "YES" and so on with all the slicers.

Example:

If you notice I am filtering BB "NO" and CC "YES", but it still shows me the value of BULL that has BB "YES" and CC "NO". Which is incorrect.

Thank you very much for the help 😣

[v-kkf-msft · Accepted solution]

Hi @Ivancito111 ,

I modified it so that now there is no need to filter the Name column, you just need to add the Measure to the visual filter and set it to not blank.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

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

[Ivancito111]

First thank you, really the solution you gave me in the last message was perfect and serves me completely, but now I have more problems and I do not want to open another forum since here is all the info.

Well the problem is that I am new using DAX, I know how to program in other languages but this one is surpassing me, short story the problem is that all the graphs and cards that I have do not work with the slicer, I tried putting the measure that was created in each graph but it does not work, I attach pictures of the graphs.

 

 

 

 

 

The idea is that when modifying the slicers, these graphics and measurements will also change.

I include idea.

 

If it wasn't so urgent I wouldn't ask for so much help, that's why I apologize but it's costing me more than it should something that seems so simple.

Thank you in advance.
Regards,

[v-kkf-msft]

Hi @Ivancito111 ,

I think you need to create some measures to calculate Price\Legs.

CountRows = 
CALCULATE(
    COUNTROWS('Table'),
    FILTER( 'Table', [Measure] <> BLANK() )
)

Sum_Legs = 
CALCULATE(
    SUM('Table'[Legs]),
    FILTER( 'Table', [Measure] <> BLANK() )
)

Sum_Price = 
CALCULATE(
    SUM('Table'[Price]),
    FILTER( 'Table', [Measure] <> BLANK() )
)

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

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