Grouping table visual

[ChrisPBIUser]

Hi,

I've attempted various DAX statements in order to generate measures and columns that would create a summarised table visual, but I'm encountering difficulties in achieving the desired outcome.

My goal revolves around a table visual, labeled as Fig1, which employs four fields extracted from a table named "Allocations." Presently, this table contains 240 rows, although this count can fluctuate throughout the month.

My objective entails evenly distributing the RankT values into three distinct groups: Good, Normal, and Bad. Subsequently, I aim to identify the highest and lowest Conversion Percentages within each of these groups.

Ultimately, my aim is to generate a table visual resembling the one depicted in Fig2 and it needs to work with a selected values from a slicer. Despite my efforts, I'm struggling to realise this vision using DAX statements.

Name - column

Allocations - calculated measure

Conversion - calculated measure

RankT - calculated measure

Fig1

Fig2

[jdbuchanan71 · Accepted solution]

@ChrisPBIUser 

Take a look at this article on ABC Classification.  It should help you get what you are looking for.

https://www.daxpatterns.com/abc-classification/

[ChrisPBIUser]

@jdbuchanan71  brilliant.  Just what I needed.  Thanks