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: 

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'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.

2 Replies

  • 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.

  • bhanu_gautam's avatar
    bhanu_gautam
    Super 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