dependency error in the measure / after created a calculated calumn

[Nakiko76]

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

[BeaBF · Accepted solution]

@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

[Nakiko76 · Accepted solution]

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

[BeaBF]

@Nakiko76 please accept my answer as a solution!

BBF

[BeaBF · Accepted solution]

@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