create power BI report based on OR condition on multiple dimensions columns

[Jeni2608]

Hi,

i want to create a Power BI report which shows as below, how can i apply a OR condition on multiple dimensions while creating the report.

select EMP_NAME,DEPT_NAME,LOCATION,SALARY from EMPLOYEES a,

DEPT b,

LOCATION C

where <JON the tables>

and (DEPT_ID = 20 or LOCATION='USA')

[Jeni2608]

Thx Greg, i will try this out.

[Greg_Deckler]

@Jeni2608 Depends. In DAX, you could use SELECTCOLUMNS, NATURALINNERJOIN and FILTER. So you could create three table VAR's, one for Employees, one for DEPT (FILTER('DEPT',[DEPT_ID=20)) and one for LOCATION (FILTER('LOCATION', [LOCATION] = "USA"). Use SELECTCOLUMNS to pull just the rows you need and then NATURALINNERJOIN to join them together. 

In Power Query, similar approach, three queries, filter them and select the columns you want and then use Merge query steps to merge them together.