cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## 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?

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.

1 ACCEPTED SOLUTION
Super User

Hi @ryanyeh1123
Try these tutorials maybe they will help :

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.

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

Regards,
Rita Fainshtein | Microsoft MVP
2 REPLIES 2
Frequent Visitor

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
Super User

Hi @ryanyeh1123
Try these tutorials maybe they will help :

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.

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

Regards,
Rita Fainshtein | Microsoft MVP

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors