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 name Consider Status Zone value ASTRADERS In-transit East 34 ASTRADERS ...
  • 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.

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.