compare columns between two tables

[RishabhRishank]

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

[lbendlin]

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

[RishabhRishank]

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]

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