Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Helper III
Helper III

Measure solution instead of a column. Multiple fact tables.

I have been away from Power Bi for a while and thought this would be easy but I am stuck (probably forgetting something basic). My model looks like this





I am trying to create a table that lists projects, one particular milestone date, and all the equity records for the associated projects.

My measure to find the particular milestone date works fine against projects but as soon as I add equity I end up with what looks like an outer join all equity records against all milestones and lots of blanks.

My milestone measure is:

DateClosingMeasure =




Milestones[Milestone] = "initial closing")


Im trying to get a table visual that looks like this:



I keep getting:




I am trying to do it only with measures. It seems like I can make it work if I add a column to the project table and calculate the milestone date but I feel like I should be able to do this only with measures.


Any help pointing me in the right direciton woudl be great.

Super User
Super User

Look at your data model and ask yourself "Can I get there from here?"  You have a dimension table that controls three fact tables.  That also means you cannot control one fact table from another fact table - hence the crossjoin. 


Not saying that is a bad thing.  But sometimes the data model needs to be adjusted to the business question.

Im not tying to control filter one fact table from the other. I am just trying to report two different facts against the project. For every project select one milestone date and report the multiple equity records assocated with that project. The milestone date and project name can repeat for each equity record. 


I am simply trying to use power bi to extract some related data from mulitple tables.

Make sure that the dimension fields in the visual are coming from the dimension table.

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors