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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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

Sorry, please try now.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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