Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
We have fulfillment schema with multiple tables each having their own measures. For example
A service call have have 1+ appointments to fulfill the call with measures like: how many days to fulfill the service call, # of appointments for each call, days between appointments
Once a service call is complete we record the details (e.g. replaced part, cost of the part and labor)
So far I have the service call in the the middle of the schema with links to appointments and details with some snowflaking
Basically, I have a hierarchy of measures and was thinking there's a way to get all of them in a central table
I'll try to post sketch of the dimensional model but anyone else run into this design issue ?
Hi @Anonymous,
You can refer to the following steps to create a central measure table and move all your measure fields to it.
1, Enter data to create a new table(with single value column) as 'measure' table
2, Navigation to 'modeling' tab(top menu bar) and choose measures and modify their 'home table' properties to change measure host table to 'measure' table.
3, After finish moves all measures by changing their 'home table' properties, remove 'measure' table column field.
4, Click twice on '>' icon(top right corner of fields panel) to collapse/expand panel to update the icon of 'measure' table.
Best Regards,
Jack Chen
How is this a solution ? This is related to an accumulated fact table and not about a calculated measure table.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
96 | |
79 | |
66 | |
62 |
User | Count |
---|---|
145 | |
113 | |
105 | |
85 | |
65 |