Forum Discussion

Dalylah_23's avatar
Dalylah_23
Regular Visitor
5 years ago

Filter out column

Attempting to filter out column based on if a column is greater than or equal to a column. 

 

My dax measure is 

Filter chart= if(column) => (column),1,0

 

The reason it won't filter out is because it doesn't known the measure is based on a per day basis. How can I add per day in the statement?

 

Thank you

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Dalylah_23 , Try like

     

    a new column = if( [column1] >= [column2],1,0)

     

    or

     

     

    a new measure = sumx(table,if( [column1] >= [column2],1,0))