Forum Discussion
MAA - Calculation
Hello to all, Can I use this formula: YTD 2021 = Divide(CALCULATE(COUNTROWS(rclms_qa), FILTER(rclms_qa,rclms_qa[CONFORMITY]="OK"&&rclms_qa[Mars Year]=2021)),CALCULATE(COUNTROWS(rclms_qa), FILTER(r...
Hi Anonymous ,
I created some data:
Here are the steps you can follow：
1. Create calculated column.
Period number = VALUE(RIGHT([Period],2))2. Create measure.
Measure = var _OK=COUNTX(FILTER(ALL('Table'),[Year]=2021&&[CONFORMITY]="OK"&&[Period number]<=13),[CONFORMITY]) var _total=cOUNTX(FILTER(ALL('Table'),[Year]=2021&&[Period number]<=13),[CONFORMITY]) return DIVIDE(_OK,_total)3. 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 Anonymous ,
I created some data:
Here are the steps you can follow：
1. Create calculated column.
Period number = VALUE(RIGHT([Period],2))2. Create measure.
Measure =
var _OK=COUNTX(FILTER(ALL('Table'),[Year]=2021&&[CONFORMITY]="OK"&&[Period number]<=13),[CONFORMITY])
var _total=cOUNTX(FILTER(ALL('Table'),[Year]=2021&&[Period number]<=13),[CONFORMITY])
return
DIVIDE(_OK,_total)
3. 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.