Forum Discussion

tkavitha911's avatar
tkavitha911
Helper III
2 years ago
Solved

This is my sample input data.

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

seller nameConsider StatusZonevalue
ASTRADERSIn-transitEast34
ASTRADERSIn-transitSouth1323
ASTRADERSYet to be pickedSouth345
ASTRADERSYet to be pickedWest235
ASTRADERSYet to be pickedEast3132
ASTRADERSYet to be pickedNorth567
ASTRADERSYet to be pickedSouth2484
ASTRADERSIn-transitWest34
ASTRADERSYet to be pickedWest234
BaidyanathNagpurIn-transitSouth3
BaidyanathNagpurIn-transitWest33
BaidyanathNagpurIn-transitSouth57
BaidyanathNagpurYet to be pickedNorth34
CLEOFCOSMETICSYet to be pickedWest567
CLEOFCOSMETICSIn-transitWest2467
CLEOFCOSMETICSIn-transitNorth24
CLEOFCOSMETICSIn-transitNorth34
CLEOFCOSMETICSYet to be pickedEast65
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.