Forum Discussion

LucMarv's avatar
LucMarv
Icon for Helper I rankHelper I
4 years ago
Solved

DAX IF statement, cannot convert type

Hi, I have the following measure, which creates a natural sentence, which I then put on a hover page, to show up when a user hovers over the individual bars of a barchart.   Overview_hover_txt = ...
Need Help
  • VijayP's avatar
    VijayP
    4 years ago

    LucMarv 
    Need to unders why "&&" in the below line (Value for False Condition) . I think this is causing problem

    ("&&format(SELECTEDVALUE(Overview_MostRecentYR[Diagnoses]), "#,#")&" tumours)

     

LucMarv's avatar
LucMarv
Icon for Helper I rankHelper I
4 years ago

Yep that was it! Too bad PowerBI does not give an informative error message when this happens! 

Thanks for taking the time to help me! Much appreciated!