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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.