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/

     

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

VahidDM  pls find the below link for file .Tap name summary .thank you so much 

 

 

VahidDM's avatar
VahidDM
Icon for Super User rankSuper User
4 years ago

Anonymous 

 

You file has Directquery and I can't see your data and visuals.

Try this as a 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, 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/

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    VahidDM   i have tired in measure i am able to type calcualte function .   but values return only checking column type and Year . i want to check three values also .if three values and  scond table CMN values matched should return True  sir 

    • VahidDM's avatar
      VahidDM
      Icon for Super User rankSuper User
      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/

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        VahidDM  sir modifed the measure .   true  return only for the all   four below values  same 
        Eo_IN_tables,Eo_Out_tables,IN_Tables,CMN  
        please find the below screen shot for  your  reference . its true or false wrongly  returned sir