Forum Discussion
Filter graph using two columns from the same graph - using a shared dataset
Hello everyone,
I'm trying to display on my grah records where table1.column1 <> table1.column2 but I am using a shared dataset. I know I cannot add any new columns when using this desing, but I was hoping I could add a filter using the condition above. Am I stuck here where I have to add a column in my shared dataset?
Thanks,
add the third column x = table1.column1 <> table1.column2, and then use X in your filter
Hi hespinoza ,
Or you can create a new measure for filter:
Measure = IF(MAX(table1[column1]) = MAX(table1[column2]),1,0)If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
2 Replies
add the third column x = table1.column1 <> table1.column2, and then use X in your filter
Hi hespinoza ,
Or you can create a new measure for filter:
Measure = IF(MAX(table1[column1]) = MAX(table1[column2]),1,0)If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai