Column Comparison / Adding measure to filter

[KarthikSridaran]

Hello All,

I have a problem, it may be a simple one. I have two datasets created and two calculated columns in each based on my proj requirement, both these columns will give me numeric output.

Now i have to compare these two columns and say whether it matches, ot not matching. 

dataset1 : calculated column 

absence days = IF('dataset1'[hoursBased] = "true", 'dataset1'[hours]/8, 'dataset1'[days])

dataset2 : calculated column

timesheet = 'dataset2'[hours]/8

What i did , I created a measure that gives me a string as output like below

comp = IF(SUM( 'dataset1'[absensce days]=SUM('dataset2'[timesheet])."Match","Mismatch")

This works fine, but i can only add it to a table i couldnt add it to a filter since it is a measure. Can you please suggest me how to add a measure output to a filter or suggest me other approches to solve my issue.

Thanks in advance.

[Lilian]

Hi Karthik!

How did you solve this?

I have the same problem.

Thanks.

[KarthikSridaran · Accepted solution]

Hi Guys,

I found out a way to solve this. Thanks.