Forum Discussion

Anonymous

Not applicable

9 years ago

Solved

Writing an IF statement referencing a column, not a measure

I have a table(Part Number Master) with a column titled "BOM". The results in that Column is either null or B. I currently have the following measure locted in the Part Number Master table: Ord...

v-ljerr-msft
9 years ago
Hi Anonymous,

What data source are you using in this case? Based on my research, the error is returned by the MS SSAS server.

Reference:
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/ec842da4-2cfa-4f2b-95e3-8627ba18f622/the-operation-was-cancelled-because-of-locking-conflicts?forum=sqlanalysisservices
https://archive.sap.com/discussions/thread/3840305

Regards

Icon for Community Champion rank

Community Champion

9 years ago

You need to use an aggregation function, in this case you should be able to use VALUES function.