Forum Discussion

dancer10-10's avatar
dancer10-10
New Member
3 years ago

Help with power bi dax calculation.

I am getting an error saying Dax comparison operations do not support comparing values of text with values of type number. How to fix?    I have this formula. I am trying to see if a customer is a ...
Need Help
dancer10-10's avatar
dancer10-10
New Member
3 years ago

gained 2 = var current_customers= DISTINCT(Sales[customer ID]) var mindate = SELECTEDVALUE(Sales[YearONLY]) var selectedthreshold3= SELECTEDVALUE('Gain Loss Numbers'[numbers Gain/Loss]) var table_ = FILTER(ALL(Sales), IF(selectedthreshold3<[units],1) ) var previouscustomer= DISTINCT(SELECTCOLUMNS(table_, "customer ID", Sales[customer ID])) var newcustomer= EXCEPT(current_customers,previouscustomer) return SUMX(FILTER(Sales,Sales[customer ID] IN newcustomer),[units])

 

 

Is this correct? I am new to power bi. It says that there is not enough memory to complete operation. 

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    3 years ago

    dancer10-10 It's really tough to say. Can you post sample/example data?