Data Comparison

[hendrikw]

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: 

Column =

VAR Anzahl_Benchmark = COUNTROWS('Benchmark')

VAR Anzahl_Ubereinstimmungen = CALCULATE(

    COUNTROWS('Rainforest product'),

    INTERSECT(

        DISTINCT('Benchmark'[request_parameters.asin]), 'Benchmark'[product.variant_asins_flat],

        DISTINCT('Rainforest product'[request_parameters.asin]), 'Rainforest product'[product.variant_asins_flat]

    )

)

RETURN

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

The error message says: "Parameter is not the Correct Type." Both parameters are Text. 

Any help is appreciated and thank you very much in advance 🙂

[Anonymous · Accepted solution]

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]

@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