topic Re: Divide function in DAX Commands and Tips

Divide function

Trooz — Wed, 22 Apr 2020 15:35:34 GMT

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. 🙂

Re: Divide function

Anonymous — Wed, 22 Apr 2020 16:18:33 GMT

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

Re: Divide function

Trooz — Wed, 22 Apr 2020 16:26:57 GMT

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

Re: Divide function

Greg_Deckler — Wed, 22 Apr 2020 16:28:57 GMT

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.

Re: Divide function

Trooz — Thu, 23 Apr 2020 23:41:43 GMT

Thanks Greg_Deckler 🙂

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

Re: Divide function

Greg_Deckler — Fri, 24 Apr 2020 05:38:30 GMT

Here to help flatten the learning curve! 🙂

Re: Divide function

Anonymous — Fri, 24 Apr 2020 12:03:46 GMT

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