Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Comparing two table columns which is having Many to many relationship

 i have a two table in power bi .  i want to compare the values between two tables if values is matched it should return True  . if values not matched its should be return false . My table 1: SID  ...
Help appreciated
Help me
Help Requested
  • VahidDM's avatar
    VahidDM
    4 years ago

    Anonymous  OK try this, and update the column names in the last row of the measure 

    Status =
VAR _A =
    CALCULATE(
        MAX( vw_IntegrationDataCheck[CMN] ),
        FILTER(
            vw_IntegrationDataCheck,
            vw_IntegrationDataCheck[ColumnType]
                = MAX( Out_DataComparison_Totals[columntype] )
                && vw_IntegrationDataCheck[CalendarYear]
                    = MAX( Out_DataComparison_Totals[CalendarYear] )
        )
    )
RETURN
    IF(
        MAX( Out_DataComparison_Totals[EO_IN_Tables] ) = _A
            && MAX( Out_DataComparison_Totals[EO_Out_Tables] ) = _A
            && MAX( Out_DataComparison_Totals[ IN_Tables] ) = _A,
        TRUE(),
        FALSE()
    )

     

     

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
    Appreciate your Kudos!!
    LinkedIn:     www.linkedin.com/in/vahid-dm/

     

     

ValtteriN's avatar
ValtteriN
Icon for Community Champion rankCommunity Champion
4 years ago

Hi,

It would be good to have more information e.g. which column you are using to create relationship and what kind of error you are getting. Regardless I think you can use the following structure:

If(lookupvalue(search column, add two conditions here (4 columns in total))=blank(),False,True)

So the idea here is to check if lookupvalue matches columns in your search table and if it does return true/false.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    ValtteriN  i have used  columntype  column for relationship  between  two tables Many to Many Relationship. i am getting below Error 

     

    The column 'My table 2 [CMN]' either doesn't exist or doesn't have a relationship to any table available in the current context.