BITomS's avatar
BITomS
Icon for Solution Supplier rankSolution Supplier
3 years ago
Status:
Needs Info

Text box is not recognising measure

Hi,

 

I have created a simple measure to dynamically update a report heading (I want it to display the client name when a single client is selected, but show as 'All Suppliers' when no selection has been made):

 

Report Title = if(HASONEVALUE('DIM Client'[Name]),values('DIM Client'[Name]),"All Suppliers")
 
However, when I attempt to add this value to a text box in Power BI desktop, it does not recognise the measure. I have tried checking the QA option suggested in another post, but this doesn't work.
 
This issue is only occurring on this .pbix file, but I am not able to share the file due to the sensitive client data within it. Any suggestions?
Reports

4 Comments

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi BITomS 

    You mean, if you use the same DAX in other pbix files and add it to the a text box , there is no problem is there?

     

    Best Regards,
    Community Support Team _ Ailsa Tao

  • HeathS07's avatar
    HeathS07
    Regular Visitor
    2 years ago

    I have this issue as well - it was working fine in one report, I copied the tables' code and DAX into a much larger file (so I can't apply the changes to that file instead). I've been able to show it in a card without issues, all column types are matching... I'm stumped.

Completed Ideas