how to calculate total country value count from two column

[Girish_123]

HI team i am very new for Dax will you please help me out here 

Thanks in advance

Team 1       Team2                                 

  A                 C                   

 B                   A

C                   B

A                  B

C                  A

A                 D

A                 C         

Answer likw A = 6

                    B = 3

                   C  = 3

                   D = 1     

[smpa01 · Accepted solution]

@Girish_123  you can use a measure like this

Measure =
VAR _0 =
    UNION (
        SELECTCOLUMNS ( 'Table', "c1", 'Table'[column1] ),
        SELECTCOLUMNS ( 'Table', "c1", 'Table'[column2] )
    )
RETURN
    MAXX (
        ADDCOLUMNS (
            'Table 2',
            "freq",
                MAXX (
                    FILTER (
                        ADDCOLUMNS (
                            _0,
                            "Frequency", COUNTX ( FILTER ( _0, EARLIER ( [c1] ) = [c1] ), [c1] )
                        ),
                        [c1] = EARLIER ( 'Table 2'[column1] )
                    ),
                    [Frequency]
                )
        ),
        [freq]
    )

[AlexisOlson · Accepted solution]

Define a new table Teams as follows:

Teams =
DISTINCT ( UNION ( VALUES ( Table1[Team 1] ), VALUES ( Table1[Team 2] ) ) )

Then set up relationships with both Team 1 and Team 2 columns in the model:

You can count both columns like this:

Count =
CALCULATE (
    COUNT ( Table1[Team 1] ),
    USERELATIONSHIP ( Teams[Team], Table1[Team 1] )
)
    + CALCULATE (
        COUNT ( Table1[Team 2] ),
        USERELATIONSHIP ( Teams[Team], Table1[Team 2] )
    )

You can do it without setting up the relationships too:

Count =
CALCULATE (
    COUNT ( Table1[Team 1] ),
    Table1[Team 1] IN VALUES ( Teams[Team] )
)
    + CALCULATE (
        COUNT ( Table1[Team 2] ),
        Table1[Team 2] IN VALUES ( Teams[Team] )
    )

[smpa01 · Accepted solution]

@Girish_123  you can use a measure like this

Measure =
VAR _0 =
    UNION (
        SELECTCOLUMNS ( 'Table', "c1", 'Table'[column1] ),
        SELECTCOLUMNS ( 'Table', "c1", 'Table'[column2] )
    )
RETURN
    MAXX (
        ADDCOLUMNS (
            'Table 2',
            "freq",
                MAXX (
                    FILTER (
                        ADDCOLUMNS (
                            _0,
                            "Frequency", COUNTX ( FILTER ( _0, EARLIER ( [c1] ) = [c1] ), [c1] )
                        ),
                        [c1] = EARLIER ( 'Table 2'[column1] )
                    ),
                    [Frequency]
                )
        ),
        [freq]
    )