Forum Discussion

setis's avatar
setis
Post Partisan
6 years ago
Solved

Ignoring a relationship

Dear experts,  In the following data model   I am trying to calculate some costs in G_L that do not have a Case ID. I need to ignore the relationship between G_L and Cases.    The G_L tabl...
Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi setis 

     

    Try this

    Measure = 
CALCULATE (
    SUM(G_L[Amount]),
    G_L[DEPT] = "610",
    G_L[PROJECT] = "FO",
    G_L[G_L Account Nr] IN { "3110", "3130" },
    USERELATIONSHIP ( G_L[Posting date], 'Date'[Date] )
)

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn

     

Mariusz's avatar
Mariusz
Community Champion
6 years ago

Hi setis 

 

Try this

Measure = 
CALCULATE (
    SUM(G_L[Amount]),
    G_L[DEPT] = "610",
    G_L[PROJECT] = "FO",
    G_L[G_L Account Nr] IN { "3110", "3130" },
    USERELATIONSHIP ( G_L[Posting date], 'Date'[Date] )
)

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

setis's avatar
setis
Post Partisan
6 years ago

Hi Mariusz ,

 

It's works! WHY? 🙂 

 

Thank you so much!

  • Mariusz's avatar
    Mariusz
    Community Champion
    6 years ago

    Hi setis 

     

    I think its because of the table insight the FILTER( ) is still preserving filter context without USERELATIOSHIP applied,

    in your scenario using FILTER was not necessary or beneficial anyway.

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn