DAX Consistency Check

Thanks for the reply from danextian , please allow me to provide another insight:

Hi,  ettekul29 

Thanks for reaching out to the Microsoft fabric community forum.

I apologise, but I couldn't find the Weight column in the sample data you provided, so I'm not entirely sure what you mean by "As the formula returns 11 distinct weights where I only have 2."

In the following example, I will use the Matnr column instead of the Weight column:

1.If you only need to count the number of distinct Key values, I suggest using the following measure:

Measure = DISTINCTCOUNT ( 'Table1'[Key])

2.If your requirement is to understand why the values in the visualisation are all the same, you might need to consider replacing the ALLEXCEPT() function part with FILTER('Table1', 'Table1'[Key] = MAX('Table1'[Key])):

Measure2 = 
CALCULATE (
    DISTINCTCOUNT ( 'Table1'[Matnr] ),
    FILTER ( 'Table1', 'Table1'[Key] = MAX ( 'Table1'[Key] ) )
)

3.Here's my final result, which I hope meets your requirements.

Please note that Measure3 is your original DAX, and all the above DAX calculations are implemented as measures.

Can you share sample data and sample output in tabular format if I am misunderstanding? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.

We recommend uploading it to GitHub and sharing the link with us.When uploading a file, please be careful to delete sensitive information.

For questions about uploading data, you can try the following links:

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Solved: How to upload PBI in Community - Microsoft Fabric Community

Please find the attached pbix relevant to the case.

Best Regards,

Leroy Lu

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