Filter graph using two columns from the same graph - using a shared dataset

[hespinoza]

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,

[andre · Accepted solution]

add the third column x = table1.column1 <> table1.column2, and then use X in your filter

[v-deddai1-msft · Accepted solution]

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

[andre · Accepted solution]

add the third column x = table1.column1 <> table1.column2, and then use X in your filter