Issue with displaying my measure in a table or a Text enhancer

[Millser]

Hi I am farely new to PowerBi and I am currently working on a dash board visual that shoudl allow the viewer to see a weekly goal that is input into the list data base the weekly goal is filtered byt the following measure that I am using:

Current Literacy = COALESCE(CALCULATE(

VALUES('Scope (2)'[Comment Description]),

FILTER(

'Scope (2)',

'Scope (2)'[Term] = SELECTEDVALUE('Date/Time'[Term Number]) && 'Scope (2)'[Week] = SELECTEDVALUE('Date/Time'[Term Week Number]))),

"No focus statement current available.")

The issue that I am having is that when I go to apply this measure to the Text Enhancer or a regular table it displays an error stating that it "Cannot display this visual". I have a feeling that the reason may be because the measure is formatting the data as a whole number hower when I go to change this in teh section on the tool bar it won't allow me to change it to text I was just wondering if maybe there is an issue with my statement or there is a way for my measure to be formatted as text?

[v-jingzhang · Accepted solution]

Hi @Millser 

To my knowledge, we cannot change a measure's data type but its format. According to your measure and description, the result of this measure should be Text. I created a sample based on your description and the measure works well. You could check it from the attached pbix. 

If you still have this issue, can you show a screenshot of this problem or provide your pbix file after removing sensitive information?

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.

[amitchandak]

@Millser , try like

Current Literacy = COALESCE(CALCULATE(
max('Scope (2)'[Comment Description]),
FILTER(
'Scope (2)',
'Scope (2)'[Term] = SELECTEDVALUE('Date/Time'[Term Number]) && 'Scope (2)'[Week] = SELECTEDVALUE('Date/Time'[Term Week Number]))),
"No focus statement current available.")

[Millser]

Still not displaying anything, tried to display it as a table and as a Text Enhancer, still same error.