Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Using a measure to concatenate fields with text is removing filtering

Hi, I have an external Power BI dataset that I have connected to to create a new report. On this new report, I would like to show a series of records where a particular column is either zero or bla...
Need Help
  • johnt75's avatar
    johnt75
    4 years ago

    Try

    Event URL = 
var eventID = SELECTEDVALUE(Events[Event ID])
return IF( NOT( ISBLANK(eventID)), CONCATENATE("https://myeventorg.fakedomain/eventId=", eventID))
johnt75's avatar
johnt75
Icon for Super User rankSuper User
4 years ago

Try

Event URL = 
var eventID = SELECTEDVALUE(Events[Event ID])
return IF( NOT( ISBLANK(eventID)), CONCATENATE("https://myeventorg.fakedomain/eventId=", eventID))
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Looking for that face palm emoji.....

Its always the simple, straight forward answers.

Thanks, that's fixed it.