Questions for optimization and DAX expression

[Adwitiy_4209211]

There is one customer column as CUST_CODE which we want to create a calculated column which has the customer value which is filtered based on the REVENUE column. 
Basically we want just those customers which has revenue. So want to create a calculated column. 

I am using this formula and getting the error. 

=CALCULATE(VALUES(FACT_SALES[CUST_CODE]),[Revenue]<>blank())

[tamerj1]

Hi @Adwitiy_4209211 

the folowing calculated column returns TRUE for the customers that made revenue. 

=
NOT ISBLANK (
    CALCULATE (
        SUM ( ACT_SALES[Revenue] ),
        ALLEXCEPT ( FACT_SALES, FACT_SALES[CUST_CODE] )
    )
)

[Adwitiy_4209211]

Thank you @tamerj1 ,
I think I have failed to mention REVENUE is a measure which calculates total Revenue. 
Customer is a dimension column. 
So based on this I want a calculated column of show customers where REVENUE is not blank.  

[tamerj1]

@Adwitiy_4209211 

I understand it is a measure but I guessed it is a sum of a column. However, you can use

=
NOT ISBLANK (
    CALCULATE ( [Revenue], ALLEXCEPT ( FACT_SALES, FACT_SALES[CUST_CODE] ) )
)