topic dependency error in the measure / after created a calculated calumn in DAX Commands and Tips

dependency error in the measure / after created a calculated calumn

Nakiko76 — Mon, 26 Aug 2024 08:54:03 GMT

Hello to all,

I am actually pretty new with BI and not realy experienced. Anyway i have already somthing i need help and an explanation on following issue:

I have a table with several collumns and measures. Everything is easy and worked fine, however by the time i calculated a column with a format change, all my measures have become invalid or better said got an error.

The error says somthing like : "semantikerror! dependency error in the measure"

Actually i dont understand why this happens. the calculated column and all the measure do not have any dependencies at all.

If anyone can help me and tell me how i can prevent from this error that would be very kind. thanks in advance to all

Re: dependency error in the measure / after created a calculated calumn

BeaBF — Mon, 26 Aug 2024 12:13:59 GMT

Nakiko76 The FORMAT function in DAX converts a value to a string format, so if this column is later used in a mathematical operation, it will automatically result in an error.

BBF

Re: dependency error in the measure / after created a calculated calumn

Nakiko76 — Mon, 26 Aug 2024 12:51:52 GMT

Thank you very much! now I understand - why it aint work. 😉

Re: dependency error in the measure / after created a calculated calumn

BeaBF — Mon, 26 Aug 2024 13:35:49 GMT

Nakiko76 please accept my answer as a solution!

BBF