Forum Discussion

Sheref_Morad's avatar
Sheref_Morad
Frequent Visitor
4 years ago
Solved

Divide Function

I am trying to create a calculated column in the customer table for predicted customer incomes using the divide Function and gives me a Blank column, although the formula is correct

blank
DAX
divide
  • tamerj1's avatar
    tamerj1
    4 years ago

    Sheref_Morad 
    Here is your fil with the solution https://www.dropbox.com/t/CChylr4UPd28RtxH
    Measures are automatically wrapped with CALCULATE which forces context transition. On the other hand using the formulas directly will be extremely complicated. Therefore, use can do the following:

    Predicted Income = 
    Divide (  
        RELATED ( 'Regression Table'[y] ) - CALCULATE ( [b], ALL ( 'Regression Table' ) ), 
        CALCULATE ( [m], ALL ( 'Regression Table' ) )
    )

    This shall solve your problem.

5 Replies

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    Hi Sheref_Morad 

    I guess you have One to One relationship between the customer table and the regression table. In this case I think you've missed to wrap column [b] and column [m] with RELATED function. 

    • Sheref_Morad's avatar
      Sheref_Morad
      Frequent Visitor
      4 years ago

      Hi tamer
      thank you for answering, the problem is still the same M the other thing is  m and b are measures not columns
      Here the power Bi file I hope you yook take a look at it , specially the customer table and the regression table
      https://bit.ly/3pzNo5r 

      • tamerj1's avatar
        tamerj1
        Community Champion
        4 years ago

        Sheref_Morad 
        Here is your fil with the solution https://www.dropbox.com/t/CChylr4UPd28RtxH
        Measures are automatically wrapped with CALCULATE which forces context transition. On the other hand using the formulas directly will be extremely complicated. Therefore, use can do the following:

        Predicted Income = 
    Divide (  
        RELATED ( 'Regression Table'[y] ) - CALCULATE ( [b], ALL ( 'Regression Table' ) ), 
        CALCULATE ( [m], ALL ( 'Regression Table' ) )
    )

        This shall solve your problem.

  • johnt75's avatar
    johnt75
    Super User
    4 years ago

    Adding columns to the customer table which simply calculate [b] and [m] both return blank results, hence the blank result in your divide formula. You can use CALCULATE( [b], REMOVEFILTERS('Customer List')), which returns a value, but without a deep understanding of your model I don't know if there are only specific columns on Customer List which should have filters removed, or if there are other filters on other tables which should be removed.

  • mem's avatar
    mem
    New Member
    3 years ago

    Hello, I have the same problem. Even though I placed the correct formula the values are wrong.