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