Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
salim
Regular Visitor

Divide one column by another

‎04-21-2016 08:40 PM

I have a column saying C1 = CALCULATE(SUM(column1)). It shows 50 in one.

Then I add another column C2 = CALCULATE(COUNT(column1)). It shows 2 in the same previous row.

Then I add column C3 = C1 / C2. Then I receive 50 for the same row!

AVERAGE does not work either. Any thoughts?

 

Labels:
Message 1 of 3
882 Views
0
1 ACCEPTED SOLUTION
Sean
Community Champion
Community Champion

‎04-21-2016 09:26 PM

Convert these Columns into Measures... M1, M2 and M3

View solution in original post

Message 2 of 3
1,257 Views
0
2 REPLIES 2
Sean
Community Champion
Community Champion

‎04-21-2016 09:26 PM

Convert these Columns into Measures... M1, M2 and M3

Message 2 of 3
1,258 Views
0
salim
Regular Visitor
In response to Sean

‎04-21-2016 10:24 PM

Thank you! I guess that is because the difference between measure and column are still blurry to me. 

Message 3 of 3
863 Views
0

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

View All