Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
tkavitha911
Helper I
Helper I

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
1 ACCEPTED SOLUTION
v-kaiyue-msft
Community Support
Community Support

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")

vkaiyuemsft_0-1718674154603.png

 

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.

View solution in original post

1 REPLY 1
v-kaiyue-msft
Community Support
Community Support

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")

vkaiyuemsft_0-1718674154603.png

 

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.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.