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.

bhanu_gautam's avatar
bhanu_gautam
Icon for Super User rankSuper User
2 years ago

hendrikw , Try using below method I have changed Distinct with Values to convert the table into sets

 

Column =

VAR Anzahl_Benchmark = COUNTROWS('Benchmark')

VAR Anzahl_Ubereinstimmungen = CALCULATE(
COUNTROWS('Rainforest product'),
INTERSECT(
VALUES('Benchmark'[request_parameters.asin]), VALUES('Benchmark'[product.variant_asins_flat]),
VALUES('Rainforest product'[request_parameters.asin]), VALUES('Rainforest product'[product.variant_asins_flat])
)
)

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

 

Please give kudos and accept as solution if it helps