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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
BillyT
Regular Visitor

Can't get calculated Measure to sum

I am calculating total miles from footages by using the sum of ttl divided by 5280 in a measure.  However, in my visual table, I cannot get the Route TTL Miles to be a Total SUM of that calculation, its displaying as an average. 

8-31-2018 2-50-28 PM.png

I have searched all related threads, at a loss, thanks in advance!

 

 

1 ACCEPTED SOLUTION
v-frfei-msft
Community Support
Community Support

Hi @BillyT,

 

I made one sample here. But my Route TTL Miles could be summed up. Could you please share your pbix or sample data to me? And tell me what are your formulas?

 

Route a = SUM(Table1[FTG NEW A])+SUM(Table1[FTG UG]) 
Route TTL Miles = [Route a]/5280

Capture.PNG

 

For more details, please check the pbix as attached.

 

https://www.dropbox.com/s/i0jh1kz35la2kg8/Can%27t%20get%20calculated%20Measure%20to%20sum.pbix?dl=0

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

View solution in original post

2 REPLIES 2
v-frfei-msft
Community Support
Community Support

Hi @BillyT,

 

I made one sample here. But my Route TTL Miles could be summed up. Could you please share your pbix or sample data to me? And tell me what are your formulas?

 

Route a = SUM(Table1[FTG NEW A])+SUM(Table1[FTG UG]) 
Route TTL Miles = [Route a]/5280

Capture.PNG

 

For more details, please check the pbix as attached.

 

https://www.dropbox.com/s/i0jh1kz35la2kg8/Can%27t%20get%20calculated%20Measure%20to%20sum.pbix?dl=0

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Hi @BillyT,

 

Has your issue been solved? If any other question, feel free to let me know please.

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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