Forum Discussion
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.
Hi Guys,
I found out a way to solve this. Thanks.
2 Replies
- KarthikSridaranFrequent Visitor
Hi Guys,
I found out a way to solve this. Thanks.
- LilianRegular Visitor
Hi Karthik!
How did you solve this?
I have the same problem.
Thanks.