DAX: Counting multiple values in different columsn

Hi SteffenSchulze 

Try this code to add a new table with DAX:

Table 2 =
VAR _A =
    VALUES ( 'Table'[Year1] )
VAR _B =
    EXCEPT ( VALUES ( 'Table'[Year2] ), _A )
VAR _C =
    SELECTCOLUMNS ( UNION ( _A, _B ), "Year", [Year1] )
RETURN
    ADDCOLUMNS (
        _C,
        "Year1",
            CALCULATE (
                COUNTROWS ( 'Table' ),
                FILTER ( 'Table', 'Table'[Year1] = EARLIER ( [Year] ) )
            ) + 0,
        "Year2",
            CALCULATE (
                COUNTROWS ( 'Table' ),
                FILTER ( 'Table', 'Table'[Year2] = EARLIER ( [Year] ) )
            ) + 0
    )

Output:

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/