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

Helper IV

## Percentage

Hello,

I have the below table and want to find out the percentage of reviews attended when they are not light touch.

So if there is a review date, it was attended and was not a light review = Percent attended.

Any help would be appreciated,

thanks

 Review Date Attended Light review Percent attended 01/01/2023 Yes Yes 50% 02/01/2023 Yes No 03/01/2023 No No 04/01/2023 Yes No
1 ACCEPTED SOLUTION
Community Support

Hi  @WJ876400 ,

Here are the steps you can follow：

1. Create calculated column.

``````Percent attended =
var _countFlag=
COUNTX(
FILTER(ALL('Table'),
'Table'[Attended]="Yes"&&'Table'[Light review]="No"),[Review Date])
var _countall=
COUNTX(ALL('Table'),[Review Date])
return
DIVIDE(
_countFlag,_countall)``````
``````Flag =
IF(
'Table'[Review Date]=MINX(ALL('Table'),[Review Date]),
[Percent attended],BLANK())``````

2. Result:

Best Regards,

Liu Yang

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

1 REPLY 1
Community Support

Hi  @WJ876400 ,

Here are the steps you can follow：

1. Create calculated column.

``````Percent attended =
var _countFlag=
COUNTX(
FILTER(ALL('Table'),
'Table'[Attended]="Yes"&&'Table'[Light review]="No"),[Review Date])
var _countall=
COUNTX(ALL('Table'),[Review Date])
return
DIVIDE(
_countFlag,_countall)``````
``````Flag =
IF(
'Table'[Review Date]=MINX(ALL('Table'),[Review Date]),
[Percent attended],BLANK())``````

2. Result:

Best Regards,

Liu Yang

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

## Helpful resources

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Join our Community Sticker Challenge

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

#### Power BI Monthly Update - July 2024

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

#### Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors