Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
KatkaS
Post Patron
Post Patron

Apply percentage split on fixed value

Hello,

 

could you please help me with following...?

I would need to apply two steps to get desidered results:

 

Step 1.  I need to show / calculate the values in the first table as percentages. (blue example, Total is 100%)

Step 2.  I need to split the costs in Credit card one time fee table (red example) BASED ON THE PERCENTAGES calculated in step one.

 

Thank you very much!

Percentage.jpg

1 ACCEPTED SOLUTION
v-frfei-msft
Community Support
Community Support

Hi @KatkaS ,

 

We can create visuals as below. 

 

2.PNGCapture.PNG

 

Btw, pbix as attached.

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

View solution in original post

3 REPLIES 3
v-frfei-msft
Community Support
Community Support

Hi @KatkaS ,

 

We can create visuals as below. 

 

2.PNGCapture.PNG

 

Btw, pbix as attached.

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
Mariusz
Community Champion
Community Champion

Hi @KatkaS 

 

Please see the attached file with a solution, let me know if you have any questions

 

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

 

Thank you, Mariusz, for your time!!

But I cannot find the file, could you please guide me where to find it or perhaps you forgot to attach it?

Thank you very much!!

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors