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

Get Fabric Certified for FREE during AI Skills Fest. This week only. Secure your voucher now.

Reply
Oleg222
Helper II
Helper II

Value in other field

Hello everyone. 
Please help with the following task - there is a table with a list of indicators, such as products, and a field with dates and amounts. It is necessary to create a measure that, in visualization, would display only those products that make up more than 10% of the total amount. Products under 10% should be displayed as "Other" in the total amount row. Importantly, the measure should dynamically achieve this.
I have created an example measure in the attached file, but for some reason, it does not display the "Other" row, which is in the reference.
Please let me know if you can offer any assistance. Your help would be greatly appreciated.

 

https://drive.google.com/file/d/1KL_GQFWRQaqhYmrX_PZ44oJXlBt602py/view?usp=sharing

2 REPLIES 2
PijushRoy
Super User
Super User

Hi @Oleg222 

Please provide access to anyone for the link




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





Sorry, please try now.

Helpful resources

Announcements
May Power BI Update Carousel

Power BI Monthly Update - May 2026

Check out the May 2026 Power BI update to learn about new features.

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.