Measure in PVT & DATA MODEL PRESENT but not working

Hi,

I have different measures created in my PVT (Datamodel), all measures are working fine.

I need to convert a field in text to have the ability to insert in the colunm of the PVT.
The solution is to create a measure with the expression Dax Measure
= CONCATENATEX('Table','Table[field])
Formule is Right.

The Measure is well on the field of the PVT but not in the DataModel!
When I want to use it, nothing appear.
This is not a problem of formula, that works fine with another workbook!
Have you a idea why I have this issue in my Workbook?

Thanks
Eric

Yes I Know but impossible to share my Workbook with the problem.
When I create a sample file, the Measure is working, so itb is not a problem of the formula but well something wrong in the workbook.
I have read on Internet other people having the same issue, but no how they have repair that!

Hi Alan,

Yes I know and my formaul is working.
This behaviour appear to my Workbook with a lot of lines and two queries.
Strange that the measure doesn't appaer in the dataModel, the others measures are well present and work fine.
Don't understand.

Eric

HI,

Just to tell you that I have found the problem.
Be carefull of the format of the colunm, in m case the original format was change in the queries in Text Mode and no TEXT/123.
So the measure formula is correct but no reaction in the PVT.
Have a nice day.

Eric