Move the customized subtotal to the left side

[ryanyeh1123]

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.

[ryanyeh1123]

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

[Ritaf1983 · Accepted solution]

Hi @ryanyeh1123 
Try these tutorials maybe they will help :
https://www.youtube.com/watch?v=VRUs0pWgsdE

https://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/1447523

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.