Forum Discussion

ssjordan95's avatar
ssjordan95
New Member
3 years ago
Solved

Data puzzle with great value!

Hello! I am new to Power BI and trying to do somethign quite complicated - or so I believe. I have two columns, one with let's say 'numbers X'. I have another column with let's say 'numbers Y'. I wou...
DATATABLE
DAX
Functions
POWER BI Dax rules
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi ssjordan95 
    Please find attached sample file with the solution

    Filter Measure = 
VAR T1 = 
    VALUES ( 'Table'[numbers Y] )
VAR T2 = 
    CALCULATETABLE ( 
        VALUES ( 'Table'[numbers Y] ),
        EXCEPT ( ALLSELECTED ( 'Table'[numbers X] ), VALUES ( 'Table'[numbers X] ) )
    )
VAR T3 =
    INTERSECT ( T1, T2 )
RETURN
    IF ( 
        NOT ISEMPTY ( T3 ),
        1
    )
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi ssjordan95 
Please find attached sample file with the solution

Filter Measure = 
VAR T1 = 
    VALUES ( 'Table'[numbers Y] )
VAR T2 = 
    CALCULATETABLE ( 
        VALUES ( 'Table'[numbers Y] ),
        EXCEPT ( ALLSELECTED ( 'Table'[numbers X] ), VALUES ( 'Table'[numbers X] ) )
    )
VAR T3 =
    INTERSECT ( T1, T2 )
RETURN
    IF ( 
        NOT ISEMPTY ( T3 ),
        1
    )
ssjordan95's avatar
ssjordan95
New Member
3 years ago

Thank you very much! If I could give you a hug, I would.