Not able to drag fields to create a measure

[Anonymous]

Hi All,

I am using the directy query mode for my report. When I tried to create a measure I am not able to drag and drop the fields neither it won't prompt me the fields list, please advice.

Thanks

[Anonymous · Accepted solution]

Hi @Anonymous 

You can't reference a column in a table directly in a measure, you need to use some functions to reference a column in a table. The relevant field is only displayed when the table column is referenced in the function, for example you can use the selectedvalue() function.

e.g Measure=SELECTEDVALUE('Table'[Column])

Best Regards!

Yolo Zhu

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

[Anonymous]

@Anonymous thanks , all I am trying to do is (cola-colb)/cola

[Anonymous]

Hi @Anonymous 

If my answer can solve your problem, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards!

Yolo Zhu

[Anonymous]

@Anonymous thanks a lot