Forum Discussion

WJ876400's avatar
WJ876400
Helper IV
3 years ago
Solved

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 DateAttendedLight reviewPercent attended
01/01/2023YesYes50%
02/01/2023YesNo 
03/01/2023NoNo 
04/01/2023YesNo 
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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