Forum Discussion

LucMarv's avatar
LucMarv
Helper 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 = 

var TvsP = IF(SELECTEDVALUE(Overview_MostRecentYR[Diagnoses]) = SELECTEDVALUE(Overview_MostRecentYR[PersonsWithDx]), 
                    "", 
                    " ("&&format(SELECTEDVALUE(Overview_MostRecentYR[Diagnoses]), "#,#")&" tumours)"
            )


RETURN

"In "&max(Overview_MostRecentYR[year])&", "&format(sum(Overview_MostRecentYR[PersonsWithDx]), "#,#")&" Victorians were diagnosed with "&SELECTEDVALUE(TumourGrouping[SumPage_LvL1_label], "cancer")&TvsP&". Our most recent data shows that 5-year survival is "&format(sum(Overview_MostRecentYR[Survival]), "#.#%")&" (95% confidence interval "&format(SELECTEDVALUE(Overview_MostRecentYR[Survival_LL]), "#.#%")&"-"&format(SELECTEDVALUE(Overview_MostRecentYR[Survival_LL]), "#.#%")&" for the period "&SELECTEDVALUE(Overview_MostRecentYR[Period])&"). In "&max(Overview_MostRecentYR[year])&", "&format(sum(Overview_MostRecentYR[Deaths]), "#,#")&" Victorians died from "&SELECTEDVALUE(TumourGrouping[SumPage_LvL1_label], "cancer")&"."

 

It works where the condition is met (i.e. the IF statement returns ""):

 

 

, but I get an error when the condition is not met. The error is:

 

What can I do to let the if statement return 

 

" ("&&format(SELECTEDVALUE(Overview_MostRecentYR[Diagnoses]), "#,#")&" tumours)"
 
 
I tried 
CALCULATE(" ("&&format(SELECTEDVALUE(Overview_MostRecentYR[Diagnoses]), "#,#")&" tumours)")
but this was more out of desparation...
  • 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)

     

2 Replies

  • VijayP's avatar
    VijayP
    Community Champion

    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)

     

  • 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!