Forum Discussion

tonijj's avatar
tonijj
Icon for Helper IV rankHelper IV
2 years ago
Solved

HasoneValue and VAR combo

Hi, 

So I searched the forum, and didnt find this particular issue. 

 

What I want to achieve: 

  • A measure including Hasonevalue function to divide the Sales by e.g. EUR, KEUR or MEUR. 
  • For the value to be able to divide by the above (Thousands, Millions) I first want to do a simple calculation of "Sales X FX Rate) as some of the numbers are in different exchange rates

 

What I have:

  • Attaching a simple Excel sheet with the data and PBIX file

 

What I have managed:

  • Create a measure with the Hasonevalue function if its only the source data "Sales".

What I need help with:

  • Create a measure that not only uses the Hasonevalue function BUT as a first also takes: "Sales value X Fx Rate". 

The files on OneDrive here 

 

  • hello tonijj 

     

    does multiplying S1 with 'FX_Rate'[Price] sound good?

    Hope this will help.
    Thank you.

1 Reply

  • hello tonijj 

     

    does multiplying S1 with 'FX_Rate'[Price] sound good?

    Hope this will help.
    Thank you.