Forum Discussion
Move the customized subtotal to the left side
Hello,
I have a problem to move my subtotal customized FPYR % to the left side. (The red frame in the picture.)
I have already change the caculation of subtotal FPYR % currently. Replace the original caculation to multiply respectively. (The yellow frame in the picture.)
Also, I just want to keep the FPYR % only of my subtotal. (Don't need to show the subtotal of defect q'ty and input q'ty)
How can I write another DAX to move my subtotal customized FPYR % to the left side and just keep FPYR % only?
Please help me~
Thank you very much.
If your good end need to any information of my current DAX please inform me, I will paste it when I see your reply.
Hi ryanyeh1123
Try these tutorials maybe they will help :
https://www.youtube.com/watch?v=VRUs0pWgsdEhttps://www.youtube.com/watch?v=ExCD0vM-OEU
for more specific suggestions :
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
2 Replies
- Ritaf1983
Super User
Hi ryanyeh1123
Try these tutorials maybe they will help :
https://www.youtube.com/watch?v=VRUs0pWgsdEhttps://www.youtube.com/watch?v=ExCD0vM-OEU
for more specific suggestions :
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
What I want to be is as below.
Stage Customize SubTotal NR. FLB Test N2.FCT-1 Unit P/N Overall FPYR % FPYR % Defect Q'ty Input Q'ty FPYR % Defect Q'ty Input Q'ty 1 74.86% (=90.91%*82.35%) 90.91% 1 11 82.35% 3 17 2 87.68%
(=96.38%*90.97%)
96.38% 5 138 90.97% 13 144 3 94.13%
(=98.44%*95.62%)
98.44% 26 1667 95.62% 73 1665 4 0% 0% 1 1 100% 0 2 Total 93.40%
(=98.18%*95.13%)98.18% 33 1817 95.13% 89 1828
