Forum Discussion

elflakoconk's avatar
elflakoconk
Helper II
6 years ago

Error using RELATED

Hello everyone, I have searched all over the forum and I have not found an answer that will solve me. I'm working with Direct Query, I have 2 tables: The link field is Phone and as you...
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi elflakoconk ,

You can create a measure as below:

Measure = 
VAR _btelefono =
    CALCULATE (
        MAX ( 'B'[Telefono] ),
        FILTER ( 'B', 'B'[Telefono] = MAX ( 'A'[Telefono] ) )
    )
RETURN
    IF ( NOT ( ISBLANK ( _btelefono ) ), "Si", "No" )

Best Regards

Rena

elflakoconk's avatar
elflakoconk
Helper II
6 years ago

Thank you very much, this worked!!! The Microsoft team told me that interactions with DirectQuery may present some flaws with SQL Server, in my case it happened, but this is resolved.

Thanks a lot.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi elflakoconk ,

    If the problem has been resolved, could you please mark the helpful post as Answered? It will help others in the community find the solution fast when they face the same problem with you. Thank you.

    Best Regards

    Rena