Dear Community,

I want to calculate an average error rate for each year under certain conditions. Even though it may seem quite simple, I receive an incorrect result. 

This is my formula:

COUNT (DISTINCT (“Table”.”Column”))

/

COUNT (DISTINCT (“Table”.”Column”)).

The KPI “2023” has the following conditions as filters:

Do you have any idea what is wrong with my formulas? 

Many thanks and kind regards,

Varvara