Forum Discussion

KarthikSridaran's avatar
KarthikSridaran
Frequent Visitor
9 years ago
Solved

Column Comparison / Adding measure to filter

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.

2 Replies

  • Lilian's avatar
    Lilian
    Regular Visitor

    Hi Karthik!

     

    How did you solve this?

    I have the same problem.

     

    Thanks.