Difference between measures - Fields

[Anonymous]

Hi,

Can anyone tell me what is the difference between these two measures?

I've used the same DAX formula, but still power BI is making some differnce and I don't know why. I have problem when I want to use one of measures, I get error that it can't be used.

Thank you in advance!

[Mariusz]

Hi @Anonymous 

The one that looks like a calcuator is a Measure and the other one is a Column, to find out more please check this article https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/

Regards,
Mariusz

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

[Anonymous]

Thank you @Mariusz !

I've created both of them via New quick measure, how is possible that one is created as column and the other one as measure?

Regards,

Milena

[Mariusz]

Hi @Anonymous 

What Quick Measures heve you used?

Thanks

Mariusz

[Anonymous]

Hi @Mariusz 

I've been using the same calculation for both measures.

Thank you,

Milena

[Mariusz]

Hi @Anonymous 

I'm surprised that it did retun a column, but anyway if one of them works just use it as long as it gives you the resoult you need.

Many Thanks

Mariusz

[Anonymous]

Hi @Mariusz 

The result is OK (numbers), but I can't use it for further calculations. I need it to be measure, not column.

Thank you!

Milena