Where clause with 2 columns

Question

Hi Guys&nbsp;I'm still new in powerBi. I'm trying to do a condition with 2 columns. Column A (Current Value) &lt; Column B(Min Level) then it should filter only the value out. Any Dax recommendation?&nbsp;Thanks!

camargos88 · Answer

Hi&nbsp;Anonymous&nbsp;,&nbsp;Difficulty to say anything without examples of your case.&nbsp;Ricardo

anonymous · Answer

Hi&nbsp;camargos88&nbsp;Attached as example. When ROB &lt; Min level, it should display Item A and B.&nbsp;

camargos88 · Answer

Anonymous&nbsp;,&nbsp;What are you trying to do ? Filtering this result as table or just showing the values on a table visual ?&nbsp;&nbsp;&nbsp;&nbsp;

anonymous · Answer

Hello&nbsp;camargos88&nbsp;&nbsp;Table Visual. Thanks.

camargos88 · Answer

Anonymous&nbsp;,&nbsp;You can use something like:&nbsp;_Measure = CALCULATE(DISTINCT(TABLE[ITEM]); TABLE[ROB] &lt; TABLE[MIN_LEVEL])&nbsp;Did I answer your question? Mark my post as a solution!Ricardo

Forum Discussion

Where clause with 2 columns

7 Replies

Related content

NOT in clause in DAX

COUNT is 0 when nullable column in where clause?

Where Clause for Custom Column

row filter with multiple clauses

Join with Clauses