Forum Discussion

Adwitiy_4209211's avatar
Adwitiy_4209211
New Member
3 years ago

Questions for optimization and DAX expression

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())

DAX
optimize

3 Replies

  • tamerj1's avatar
    tamerj1
    Community Champion
    3 years ago

    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's avatar
      Adwitiy_4209211
      New Member
      3 years ago

      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's avatar
        tamerj1
        Community Champion
        3 years ago

        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] ) )
)