Grouping data for a visual

[TaariqHussain]

I have 2 tables items sales and a second that has item cost

both linked to master inventory table

I have a measure that calculates my GP% however i want to group my GP's as per below

thats where this formula i found on the forum comes in

Measure =

VAR __Date = MAX('ItemWiseSales'[dateinvoiced])

VAR __Category = MAX('Category'[Category])

VAR __Low =

SWITCH(

    __Category,

    "Less than 1%",-0.2,

    "1%",0.01,

    "2%",0.02,

    "3-5%",0.03,

    "5%>",0.05

)

VAR __High =

SWITCH(

    __Category,

"Less than 1%",0.01,

    "1%",0.019,

    "2%",0.029,

    "3-5%",0.049,

    "5%>",0.2

)

VAR __tmpTable = SUMMARIZE('ItemWiseSales',ItemWiseSales[itemprice],"__Percent",[GP%])

RETURN COUNTROWS(FILTER(__tmpTable,[__Percent]>=__Low && [__Percent]<=__High))

i than pull that measure into a pie chart but the visual is completely off

Please assist on a fix or possible alternative

original formula from a reply by @Greg_Deckler on different post

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[TaariqHussain]

Good day

Thank you for your response

As per above this a sample of a visual i want to see

With that i also want to drill down each slice to see the items in that GP% range

below is my 3 sample data sources

Item sales

Barcode	Product Description	Unit Price
FRBR8	FRANGOSA BRAAI PACK 8X800G FZN	36.9
3C5	CHUBBY CHICK IQF 3X5KG	29.75
C26	CHUBBY 6X2KG IQF	29.8
RHF	Rainbow Head And Feet 10x1kg	12.5
DCD10	DS - FRESH DRUMSTICK 10Kg	45.5
3R5MP	RB IQF MIX PORTIONS 3X5KG	30.5

Last GRV Cost

Item Code	Item Description	Last Invoice Cost
3C5	CHUBBY CHICK IQF 3X5KG	28.03
3R5MP	RB IQF MIX PORTIONS 3X5KG	32.87
C26	CHUBBY 6X2KG IQF	28.03
DCD10	DS - FRESH DRUMSTICK 10Kg	44
FRBR8	FRANGOSA BRAAI PACK 8X800G FZN	28.5
RHF	Rainbow Head And Feet 10x1kg	9.98

Master stock data

Item Code	Item Description
RHF	Rainbow Head And Feet 10x1kg
3C5	CHUBBY CHICK IQF 3X5KG
C26	CHUBBY 6X2KG IQF
FRBR8	FRANGOSA BRAAI PACK 8X800G FZN
3R5MP	RB IQF MIX PORTIONS 3X5KG
DCD10	DS - FRESH DRUMSTICK 10Kg

Thank you