Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
59 | |
22 | |
18 | |
18 | |
16 |
User | Count |
---|---|
87 | |
59 | |
52 | |
37 | |
21 |