DAX is returning incorrect values.

[DavidProfi]

Hello!
The following problem:
I'm trying to compare a larger set (17) ('Vergleich Styp' [22026]) with one number ('voest' [22026]) using this DAX expression (linked with [Stahltypen]).

The first part determine the count of values smaller than 'voest' [22026], and in the second part, determine the count of values greater than 'voest' [22026], in order to calculate the average.
Except for the last line, the rest is NOT correct; the last line is correct.

What is the reason for this, and why are the other values all periodic?

It's also correct that there are no values in 2023 and 2024

Thank you in advance.

[Anonymous]

Hi @DavidProfi ,

Can you provide some sample data and your desired output? It's hard to tell what the problem is with the DAX alone.
You can try modifying this place first:

DAX is modified as follows:

ALL('Vergleich Styp')

If this is incorrect, please also provide sample data or a pbix file and remember to provide the correct result you want!

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.