Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
admin_xlsior
Post Prodigy
Post Prodigy

Table filter with two field condition

Dear all,

 

When we have table visual, how to set filter with 2 field with OR condition ?

I have like this ->

admin_xlsior_1-1637754217276.png

Both are Measures so both are already a calculation of some other original data table, and I want if either of them has value, show the line (record) else hide.

But I cannot just add new measure and SUM those two and see if there is a value in it, since it is probaby negate each other (plus minus). 

 

Can we do something with the Built-in Filter from Power BI ? The Filter is act as "AND", right ? not "OR". So any trick for this kind of situation ?

 

Thanks,

 

 

 

1 ACCEPTED SOLUTION

Hi,

 

This is solved. Just realized I actually only need to add those 2 measure with ABS() function for each. The result will be zero whenever both are zero, then I can use it in "Filter on this visual"

 

Thanks.

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

@admin_xlsior , To have or using slicer you need them to come from two independent tables  

 

then a measure like

calculate(sum(Table[Value]), filter(Table, Table[A] in allselected(A[A]) && Table[B] allselected(B[B]) ) )\

 

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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Hi,

 

If possible, I don't want to have any addition table into it. Can we maintain this on the visual it self ? Because I think this is just a matter of display or not. But I hope I'm right.

 

So, as mentioned, this two value are measures and in my Table Visual only listed/display these two measure and 1 more from a dimension table related to that measure. 

 

So for example, Measure A and B are SUM of Gross and Net sales (from Order table) and the other column I included in that Table Visual is Customer (from Customer table which related to Order table). This is however only example, and what I needed is whenever the A or B has value, show the line, if both has zero value, hide it.

 

Hope it is more clear.

 

Thanks

 

 

 

 

 

Hi,

 

This is solved. Just realized I actually only need to add those 2 measure with ABS() function for each. The result will be zero whenever both are zero, then I can use it in "Filter on this visual"

 

Thanks.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.