Forum Discussion

Trooz's avatar
Trooz
Helper I
6 years ago
Solved

Divide function

Hi friends,   I'm sorry to make this question, but I was trying to simulate an assignment and I found that they used DAX "DIVIDE" to create this table and to make it also appear in the "Data model ...
DAX
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Trooz ,

     

    Incase you want to create a calculated column, you will need to click on the calculated column and not a measure.

     

     

    Try creating a column and you can perform the Divide function.

     

    Regards,

    Harsh Nathani

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago
Any time you reference a column in a measure, you must use an aggregation like MIN, MAX, SUM, AVERAGE, etc.

The function you are using has nothing to do with it, any function will exhibit the same behavior in a measure calculation.
Trooz's avatar
Trooz
Helper I
6 years ago

Thanks Greg_Deckler ğŸ™‚

you know those are my first days with Power BI so I still need to learn 🙂