Calculate data by filter year (help)

[Syndicate_Admin]

hello, I am updating my report from 2021 to 2022 and I am having some problems... for example I need the results delivered to be based on the year selected

the formulas I currently have are as follows:

HH = CALCULATE(COUNTROWS(HH),HH[año]="2021" (I need to add the year 2022, and modify it in the database, as I show in the image below)

IF = calculate(([CTP]+[FATAL])*1000000/(SUM(HH[HH]))) when occupying this formula, it considers me all man hours (hh), so I need to decriminalize according to year

Thank you

[VahidDM · Accepted solution]

Hi @Syndicate_Admin 

If you want to add 2022 to the countrows you can use this:

CALCULATE(COUNTROWS(HH),Filter(HH,HH[año]="2021"&&HH[año]="2021"))

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/