Divide value of 2 columns

[Charlie42]

Hi everyone,

Into my table, I would like to add a column with as value the division of two other columns.

In the first time, for trying, I tested with the substraction, and it works:

But, now, if I want calculate the division I have a blank value...

I also tried with 

Diff % = SELECTEDVALUE('Sales 2023'[RE Sale]) / SELECTEDVALUE('Sales 2023'[LY Sale])

or simply

Diff % = 'Sales 2023'[RE Sale] / 'Sales 2023'[LY Sale]

but the result is the same.

Could you help me?

Thanks in advance.

PS: I tried with a measure. It works, but my problem is I have to do this calculation in several table (2022, 2021, 2020) and, after that I merge my tables... And here I have a new problem with the value.

Thanks for your help.

Charles.

[Charlie42]

Hi @olgad ,

As you can see, I already tried with DIVIDE and it doesn't work.

'Re Sales' and 'LY Sales' are columns. 

[olgad]

Hi,
Using  / is not a good idea, try to use DIVIDE(RE Sale, LY Sale)  Re Sale na dLY Sale are those measures or columns?