Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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')
Thx Greg, i will try this out.
@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.
User | Count |
---|---|
86 | |
84 | |
69 | |
67 | |
55 |
User | Count |
---|---|
125 | |
100 | |
90 | |
84 | |
66 |