This is my sample input data.

[tkavitha911]

I would like to check if each seller level and zone level is at 100%. Could you please assist with this?

seller name	Consider Status	Zone	value
ASTRADERS	In-transit	East	34
ASTRADERS	In-transit	South	1323
ASTRADERS	Yet to be picked	South	345
ASTRADERS	Yet to be picked	West	235
ASTRADERS	Yet to be picked	East	3132
ASTRADERS	Yet to be picked	North	567
ASTRADERS	Yet to be picked	South	2484
ASTRADERS	In-transit	West	34
ASTRADERS	Yet to be picked	West	234
BaidyanathNagpur	In-transit	South	3
BaidyanathNagpur	In-transit	West	33
BaidyanathNagpur	In-transit	South	57
BaidyanathNagpur	Yet to be picked	North	34
CLEOFCOSMETICS	Yet to be picked	West	567
CLEOFCOSMETICS	In-transit	West	2467
CLEOFCOSMETICS	In-transit	North	24
CLEOFCOSMETICS	In-transit	North	34
CLEOFCOSMETICS	Yet to be picked	East	65

[Anonymous · Accepted solution]

Hi @tkavitha911 ,

1. You can create measure.

Status Percentage =
COUNTROWS ( 'Table' )
/ CALCULATE (
COUNTROWS ( 'Table' ),
ALLEXCEPT ( 'Table', 'Table'[Seller Name], 'Table'[Zone] )
)

2. If you want to show if it is 100%, you can create MEASURE.

Is 100% = IF([Status Percentage] = 1, "Yes", "No")

If this is not the result you are expecting, please let me know more information using other means such as screenshots or dummy tables so that we can better help you solve the problem.

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.