Forum Discussion

hendrikw's avatar
hendrikw
New Member
2 years ago
Solved

Data Comparison

Hello there 🙂 I was wondering if someone could help me with my problem. Currently I am trying to compare 2 different tables and check for differences between the two. I wrote this DAX-Code:  Colu...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi hendrikw ,

     

    Modify your formula like below:

    result_ = 
VAR Anzahl_Benchmark =
    COUNTROWS ( 'Benchmark' )
VAR Anzahl_Ubereinstimmungen =
    CALCULATE (
        COUNTROWS ( 'Rainforest product' ),
        INTERSECT (
            DISTINCT ( 'Benchmark'[request_parameters.asin] ),
            DISTINCT ( 'Rainforest product'[request_parameters.asin] )
        ),
        INTERSECT (
            DISTINCT ( 'Benchmark'[product.variant_asins_flat] ),
            DISTINCT ( 'Rainforest product'[product.variant_asins_flat] )
        )
    )
RETURN

    IF (
        Anzahl_Benchmark = Anzahl_Ubereinstimmungen,
        "Load Successful",
        "Load Failed"
    )

    Best Regards,
    Adamk Kong

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi hendrikw ,

 

Modify your formula like below:

result_ = 
VAR Anzahl_Benchmark =
    COUNTROWS ( 'Benchmark' )
VAR Anzahl_Ubereinstimmungen =
    CALCULATE (
        COUNTROWS ( 'Rainforest product' ),
        INTERSECT (
            DISTINCT ( 'Benchmark'[request_parameters.asin] ),
            DISTINCT ( 'Rainforest product'[request_parameters.asin] )
        ),
        INTERSECT (
            DISTINCT ( 'Benchmark'[product.variant_asins_flat] ),
            DISTINCT ( 'Rainforest product'[product.variant_asins_flat] )
        )
    )
RETURN

    IF (
        Anzahl_Benchmark = Anzahl_Ubereinstimmungen,
        "Load Successful",
        "Load Failed"
    )

Best Regards,
Adamk Kong

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.