Divide function

[Trooz]

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 view" , despite that as far as I know "Measures" appear only in the "Report view".

But when I try to do the same step by clicking "New measure" and selecting "Divide function" it doesn't suggest the columns that I should divide or divide by. I changed the column format to "Whole number" but I still unable to select the coulmns to complete the measure. 

Many thanks to you all. 🙂

[Greg_Deckler]

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]

Thanks @Greg_Deckler 🙂

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

[Anonymous]

https://www.youtube.com/watch?v=78d6mwR8GtA

https://www.youtube.com/watch?v=_quTwyvDfG0

https://www.sqlbi.com/tv/time-intelligence-in-microsoft-power-bi/

Something to watch and start with...

Best
D

[Greg_Deckler]

Here to help flatten the learning curve! 🙂

[harshnathani · Accepted solution]

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

[Trooz]

Thanks @harshnathani , I was a quite confused between both things, now it's very clear 🤗