The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I feel like this should be a basic question, but I can't get my head around it. I'm trying to filter multiple dimension tables that have a common field. Example I have 2 dimension tables (Employee and Orders). Both Employees and Orders have a column of Division.
Employee and Order are not related, but there are employee transactions for each order. So if I use the Division table as a bridge, it creates ambiguity for the transactions. How would I go about filtering out Employees and Orders by Division?
@froelichgr , Ideally you should merge employee and division and use that as dimension
My problem with that is the Mfg Orders don't have a relationship with employee
Did you manage to solve this? I have the same issue