Forum Discussion

PrieleBI's avatar
PrieleBI
Frequent Visitor
1 year ago
Solved

Measure from two fact tables

Hello,

 

I have three dim tables and two fact tables. I have coloured the related wolumns with specific colours.

In the snip you can see the resulta, that I need.

Could you help me with measure DAX? How how to write measure, that could give me result like this.

Note: i cant change models structure, true tables are much more difficult

 

 

 

 

 

Need Help
  • Irwan's avatar
    Irwan
    1 year ago

    hello PrieleBI 

     

    please check if this accomodate your need.

     

    i am not sure why 202506 use 0,8 as koef value (looking at your data, it should be 0,6)

     

    also i assumed you will always have same DateCode in Fact1 and Fact2.

     

    Hope this will help.

    Thank you.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    1 year ago

    Hi,

    Another approach would be to merge (in Power Query) Fact Table 2 and Dim tble 1 into Fact table 1.  Now your calculations should be simple.

6 Replies

  • Irwan's avatar
    Irwan
    Super User
    1 year ago

    hello PrieleBI 

     

    please check if this accomodate your need.

     

    i am not sure why 202506 use 0,8 as koef value (looking at your data, it should be 0,6)

     

    also i assumed you will always have same DateCode in Fact1 and Fact2.

     

    Hope this will help.

    Thank you.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    1 year ago

    Hi,

    Another approach would be to merge (in Power Query) Fact Table 2 and Dim tble 1 into Fact table 1.  Now your calculations should be simple.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi PrieleBI,

     

    thanks to Irwan and Ashish_Mathur  for the prompt and helpful response.

     

    we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
    If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

     

    Regards,
    Prasanna kumar

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi PrieleBI, 

     

    we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?

    If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

     

    Regards,

    Prasanna Kumar

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi PrieleBI,

    Just a gentle reminder — has your issue been resolved? If so, we’d be grateful if you could mark the solution that worked as Accepted Solution, or feel free to share your own if you found a different fix.

    This not only closes the loop on your query but also helps others in the community solve similar issues faster.

    Thank you for your time and feedback!

     

    Regards,

    Prasanna kumar

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi PrieleBI,

    Just a gentle reminder — has your issue been resolved? If so, we’d be grateful if you could mark the solution that worked as Accepted Solution, or feel free to share your own if you found a different fix.

    This not only closes the loop on your query but also helps others in the community solve similar issues faster.

    Thank you for your time and feedback!

     

    Best,

    Prasanna Kumar