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
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

dancer10-10 Check the data types of your columns, number and year and make sure they are all set to Whole number or Decimal. Or, you can always do +0 to make sure any numeric text gets converted to a number.

 

Also, I have no idea what this line is:

calculate(countrows, filter, values(sales[customerID]), 

calculate(units, 'time'[year]=currentyear)>= selectedthreshold && calculate(units, 'time'[year]= prioryear)<selectedthreshold )))

 

It doesn't look right at all.

 

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

Thank you. Do you know the correct logic to get the formula that I want to get based on the description above? 

    • 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?