Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Trooz
Helper I
Helper I

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

 

modelview.png

 

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

1 ACCEPTED SOLUTION
harshnathani
Community Champion
Community Champion

Hi @Trooz ,

 

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

 

123.JPG

 

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

 

Regards,

Harsh Nathani

View solution in original post

6 REPLIES 6
Greg_Deckler
Community Champion
Community Champion

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.


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Thanks @Greg_Deckler 🙂

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

Here to help flatten the learning curve! 🙂


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...
harshnathani
Community Champion
Community Champion

Hi @Trooz ,

 

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

 

123.JPG

 

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

 

Regards,

Harsh Nathani

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.