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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.