Forum Discussion

lbendlin's avatar
lbendlin
Super User
5 years ago

Don't have an answer but I am curious to learn about the use case.  To me this feels like a solution in search of a problem, and something that can potentially confuse the report users (as they may have different expectations).

pbiembeded's avatar
pbiembeded
Regular Visitor
5 years ago

Sure Thanks for response. Here is requirement.

Let's say we have 2 entity:

1. Profession
o Manager
o Lead
o Product Owner
o Business Analyst
o Developer
o Tester
2. Clients
o Walmart
o Costco
o BJ’s
o Target
o Best Buy
o Acme

Just sample data.
Profession = 'Developer' AND Client = 'Walamart'
Profession = 'Developer' OR Client = 'Walamart'

Year     Efforts(AND) Efforts(OR)

2007     104                1040  

2008     120                860

2009     56                   440

 

Using OR Query, I get efforts put by developer for all clients in Same report. But because of Power BI default behavior of AND I am not able to get the exact records.