filter column using set analysis

[Anonymous]

Hello everyone, I am trying to learn this program but I am stuck somewhere, I read at least 20 topics but I seem to miss a point.

I have a table like this:

Col A	Col B
XX	25
YY	30
XX	15
YY	40

I am trying to filter them using Col B, and show the Col A data in a graph. But I can't apply the filter.

To find the rows with Col B > 20, what should I do?

I created a chart with Col A values, I click set analysis, and apply below func there but nothing changes.

AGGR( ONLY ( {$<[Col B]={'>20'}>} [Col A] ) , [Col A]  )

What am I missing?

[sunny_talwar]

Did you try using an expression like this?

Sum({<[Col B] = {">20"}>}[Col B])

I am assuming you have Col A as dimension in your graph

HTH

[NZFei]

=if([Col B]>20, [Col A])