October 28 & 29: Experts share their secrets on how to pass the Fabric Analytics Engineer certification exam—live. Learn more
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 |
Solved! Go to Solution.
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
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
User | Count |
---|---|
105 | |
99 | |
98 | |
86 | |
49 |
User | Count |
---|---|
162 | |
142 | |
132 | |
102 | |
63 |