Forum Discussion
DAX or Query: Compare two columns in different Tables
Hi Anonymous
here you go
Attached the file
https://drive.google.com/file/d/1hMWpl1vwwXlj8yDKT8vmXLUF7S207jUU/view?usp=sharing
Hey add this to the measure if you don<t want to count the Blank rows
Count of MisMatch = CALCULATE(COUNTROWS(OEC_Service_Requests) , OEC_Service_Requests[Match/No Match__] = "No Match", OEC_Service_Requests[Status_Code ESR] <> BLANK())
link
Here is your file corrected
I changed the way of calculation: I added 2 columns to OEC_ Table:
I renamed the "No need table" and "No need measure" delete them if you want.
Hope you like it😁
aj1973 thank you! There is an issue - the value are not suppose to be empty in the ESR status when there is no match it should have a value.
I'm not sure if its because I determined a 1:1 relationship.
Indeed, 1:1 relationship is not recommended
Better way is to add a Calendar Table and
but you are going to need to change some calculations.
another way is to filter out the Blank rows from the filter pane.
Hey add this to the measure if you don<t want to count the Blank rows
Count of MisMatch = CALCULATE(COUNTROWS(OEC_Service_Requests) , OEC_Service_Requests[Match/No Match__] = "No Match", OEC_Service_Requests[Status_Code ESR] <> BLANK())Thank you !! aj1973 this has worked!! 🙂