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'm having trouble with the total for a particular column.
Try to put together a measure, which works differently depending on the level of granularity. And I'm happy with the results, but when it gets to the total, I need the results it shows to be different than what it's showing now.
In the image are all the details, but I will try to explain it too.
Specifically, I need the "total" column "mts / min", to show the division of the total column "Distances (m)" / the total column "Duration (min).
Add the formulas that I use in the picture and send the pbix file
I'm not sure you can actually do that.
Thank you
https://drive.google.com/file/d/1D7KQmIcsvkCn8lDJnbm2rkIROCZQmtf1/view?usp=sharing
Solved! Go to Solution.
https://community.powerbi.com/t5/Power-Query/Row-Total-Average/td-p/965757
This might help you
You need a conditional statement to show diffrent values for totals
https://community.powerbi.com/t5/Power-Query/Row-Total-Average/td-p/965757
This might help you
You need a conditional statement to show diffrent values for totals
I solve
thanks
I wanted to thank you. I implemented ISINSCOPE, and it worked.
The values are correct, but now if some athletes did exercise A, it shows me the data of exercise A, but it also shows me values in those players who did not do those exercises.
I hope you understand what I mean.
Thanks.
OK, I'm new to all this, I'll try to use your suggestion.
From already thank you very much.
Diego
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 |
---|---|
49 | |
26 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
43 | |
19 | |
18 |