Power BI file stopped supporting any text measures

[pirdim]

Hello, the issue is that my .pbix file at some point stopped supporting any "Text" measures.
So if for example I create a simple measure = "aaa" which under normal circumstances would be formatted as "Text", in my file it is formated as "General". And if I try to manually change it using Measure Tools -> Format from "General" to "Text"... nothing happens. It is still "General". The only workaround I found is using TabularEditor. I can manually change format to "Text" there. This helps to use text measures in titles for visuals but in my scenario I need to use text measure inside of text boxes (like built-in smart narrative visual but with my own text). And in text boxes any such "artificially" created "Text" measures are simply ignored (smart narrative cannot recognize the Result for them so nothing is shown on their place).

[pirdim]

ok, after some time with that issue I think I found the reason of the problem. It was calculation group I created. It was desinged to show "Simple" result (using just SELECTEDMEASURE) and more complex result with error text instead of showing measure (using code like if condition is true show "error text" otherwise use SELECTEDMEASURE). And this thing messed up the whole .pbix file deleting possibility to create ANY "Text" measure in the file. Maybe this is expected behaviour but that was really weird to me. 

[v-cazheng-msft]

Hi @pirdim ,

If you still have problems on it, could you please provide a download link of a sample pbix file containing your issue if it is convenient for you and tell your expected result so I investigate on it? Thanks in advance!

Best Regards,

Community Support Team _ Caiyun

[pirdim]

hi @v-cazheng-msft 

Please find a link to the simple .pbix file I created to show the issue (link goes to OneDrive, but should be available to you):
SimpleModel to show the issue.pbix

I added all comments in file so it will be easy to understand the issue there. There is 1 table with 1 column which I refer to in my text measure. And also 1 calculation group, which has 1 specific calc item causing the issue. Also there is a workaround but I don't really like it. 

[v-cazheng-msft]

Hi @pirdim ,

Thank you very much! I can download this sample file and  I’ll investigate with it. Once there is any update, I will post here. Thanks for your understanding!

Best Regards,

Community Support Team _ Caiyun

[v-cazheng-msft]

Hi @pirdim,

It’s caused by the known limitation of smart narratives summaries (ICM 295304333). Semantic query used to handle smart narratives summaries have problem on handling measure containing data like text. Product group is still investigating on it. No expected fix time provided for now. Currently, please make some changes to your Measure to avoid the issue or take Tabular Editor tool help you regulate this Measure. Thanks in advance!

Best Regards,

Community Support Team _ Caiyun