I have two fields from 2 different projects that contain text. They are the same field and i want to show the results in one column, how do i create a custom measure that adds them together (one of the columns will always be blank).
Welcome to the Community!
IIf([Measures].[One project text]="(none)", [Measures].[Other project text], [Measures].[One project text])
Replace the names of the measures with your according names. This formula will check if the text from the first project is empty or (none), then it will use text from the other project, but if it is not empty, it will take the text from this first project.
Let me know if this fits your use case or if you have any additional questions on this!
Nauris / eazyBI support