Forum Discussion

AlessandroFossi's avatar
AlessandroFossi
New Member
2 years ago
Solved

Euclidean Distance measure with DAX

Dear Community,    I found myself stuck with this formula in DAX, seems ok because the editor does not throws an error but the measure is always zero in power BI charts.  The measure is intended t...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi AlessandroFossi ,

    I looked at your DAX code and copied your values into Power BI and found the problem to be the following.

    For this part of the image below, he needs to recreate two new tables.

    You are using the NATURALINNERJOIN function, the join function 'NATURALINNERJOIN' requires at-least one common join column. So I think you can modify your code a bit.

     

     

     

    Best Regards

    Yilong Zhou

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi AlessandroFossi ,

I looked at your DAX code and copied your values into Power BI and found the problem to be the following.

For this part of the image below, he needs to recreate two new tables.

You are using the NATURALINNERJOIN function, the join function 'NATURALINNERJOIN' requires at-least one common join column. So I think you can modify your code a bit.

 

 

 

Best Regards

Yilong Zhou

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