Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
petersenpedrog
New Member

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
)

petersenpedrog_0-1702916015758.png

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

 

2 REPLIES 2
ValtteriN
Super User
Super User

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/





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




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 !

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.