Increase granularity of Fact table

[erikmi]

I have following Problem:

I have a Fact Table with revenues on a Projekt Level. 

Every Porjekt belongs to one ore more funds. 

Now I have a extra table that defines the percentages of the Projects for each fund.

How can I analyse the actual Revenue of the funds. 

Do I need to increase the granularity of both fact and dimension tables in powerquery or is there a daxmeasure I can use?

[amitchandak · Accepted solution]

@erikmi , with a common dimension you should be able to analyze.

You can take help from Sumamrize or values to group data at different level

example

Sumx(Values(Project[Project]), calculate(Max(fact[Value]) ) )

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.