Reply
avatar user
Anonymous
Not applicable

parent with multiple children

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 ?

 

 

2 REPLIES 2
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
avatar user
Anonymous
Not applicable

How is this a solution ?  This is related to an accumulated fact table and not about a calculated measure table.

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)