Forum Discussion

RishabhRishank's avatar
RishabhRishank
New Member
2 years ago

compare columns between two tables

I am working on a reconcilliation dashboard where I want to compare data coming from two different datasources
Big Data and Unified data.
I have the same tablename coming from both the tables(One table for BDP and other for UDP) where I can make the relationship. But my requirement is to compare record count between both of them against same table on daily basis.

 

Attaching belwo the data model where I want to compare hive record count vs load row count, all three tables are joined on "target table name" column

 

 

 

i want to show data like below in a matrix where I am showing the row count and hive count against table name(Row) on daily basis

My recuirement is to compare value between these two"

ex: on 7th March 1st row is  Row Count=4 and Hive record count =2 so these should be a false statement .

 

So either i want to add another column to show True/false or i can do the color formatting for each cell accordingly if true green if false thren red

 

Need Help

3 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    Sounds good. What have you tried and where are you stuck?

    • RishabhRishank's avatar
      RishabhRishank
      New Member
      2 years ago

      i have tried with this approach writing a DAX :

       
      'Comparison =
      var A = SELECTEDVALUE(UDP_INGESTION_AUDIT_LOG_2024[load_row_cnt])
      var B = SELECTEDVALUE(exportq[HIVE_REC_COUNT])
      return IF(A = B, TRUE, FALSE)
       
      but I see True even when the count doesn't match, please see the snippet below

       

      • lbendlin's avatar
        lbendlin
        Super User
        2 years ago

        what does SELECTEDVALUE  mean for your scenario?  Do you have single select slicers on these columns?