Forum Discussion

petersenpedrog's avatar
petersenpedrog
Frequent Visitor
2 years ago

Question about USERELATIONSHIP()

Hi, can you guys help me ? I have a secondary relationship on my tables and i'm using the following DAX:

    COALESCE(
    CALCULATE(
        SUMX(
            FILTER(
                'fProducaoPPC',
                'fProducaoPPC'[DataCancelamento] = BLANK()
            ),
            'fProducaoPPC'[Peso] *
            RELATED('dProducaoEventoDepartamento'[%PesoEvento]) *
            (1- (fProducaoPPC[PORCENTAGEMREAL] / 100)) / 1000
        ),
        USERELATIONSHIP('fProducaoPPC'[PK_Evento], 'dProducaoEventoDepartamento'[FK_Evento])
    ),
    0
)

It's Accutually working just fine, but it gives me this error message. Should I worry about it? 

 

2 Replies

  • ValtteriN's avatar
    ValtteriN
    Community Champion
    2 years ago

    Hi,

    If there is an error message it is not available in your picture. Generally speaking if your measure return the value you want then there isn't need to worry about it.

    I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

    My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

    • petersenpedrog's avatar
      petersenpedrog
      Frequent Visitor
      2 years ago

      Actually the underline that I was talking about, it's the red underline that It's in the picture. I was wondering if That was normal. But thanks for the help man !