cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BillyT Frequent Visitor
Frequent 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

Accepted Solutions
Community Support Team
Community Support Team

Re: Can't get calculated Measure to sum

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 other members find it more quickly.
2 REPLIES 2
Community Support Team
Community Support Team

Re: Can't get calculated Measure to sum

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 other members find it more quickly.
Community Support Team
Community Support Team

Re: Can't get calculated Measure to sum

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 other members find it more quickly.