Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
I have searched all related threads, at a loss, thanks in advance!
Solved! Go to Solution.
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
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
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
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
Hi @BillyT,
Has your issue been solved? If any other question, feel free to let me know please.
Regards,
Frank
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |