Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi,
I am building a matrix using three direct query data sets through the oracle database. They connect using one to one relationships.
Query 1 and WORKORDER connect using work order numbers
WORKORDER and FINCNTRL connect using financial control ID's unqiue to each line
the FINCNTRL table also has project numbers (not unique) that connects to an imported excel file that has a list of projects and related data
the matrix has three rows: the system window (WORKORDER), work order number (WORKORDER), and item number (Query1)
and one column category: the project category (project listing table)
the value being calculated comes from the Query1 table, which has unit price and quantity data at the item level. Multiplying those together gives the total cost. dax for this measure is a pretty simple sumx function:
@coffjoh2004 , Avoid bi-directional joins
Prefer 1-Many joins and try to use Star schema
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
92 | |
82 | |
71 | |
49 |
User | Count |
---|---|
143 | |
121 | |
111 | |
59 | |
57 |