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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Bryanna
Helper II
Helper II

Creating categories based off my measure

Hi,

 

This is a two parter question. I have a measure calculating my how often my inventory is turning. I want however to be able to group these into categories "Less than one", "greater than two", etc.  Right now it doesnt seem to be grouping some of these correctly and i cant figure out why. From there i want to create a percentage of each of these categories but its not recognizing these groups unless i have another field in the table which defeats the purpose of trying to group these if i cant see how much inventory falls into each. Help!! 😞

Bryanna_1-1679608688382.png

Bryanna_0-1679608633080.png

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Bryanna , Try Dynamic Segmentation

 

Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1...


Dynamic Segmentation, Bucketing, or Binning: https://youtu.be/CuczXPj0N-k

 

Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ

View solution in original post

2 REPLIES 2
Bryanna
Helper II
Helper II

Thanks! the Dynamic Segmentation, Bucketing, or Binning: Youtube video helped perfectly!

amitchandak
Super User
Super User

@Bryanna , Try Dynamic Segmentation

 

Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1...


Dynamic Segmentation, Bucketing, or Binning: https://youtu.be/CuczXPj0N-k

 

Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors