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 = Pe...
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

     

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