cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
mvelazquez Frequent Visitor
Frequent Visitor

Concatenating a measure or field with a text

Hello PowerBI Gods!

 

Hope all is well and thank you in advance.

 

Here is my issue. So I have a table (see picture) that has a bunch of IDs and names. What Im trying to achieve, is that if the column defaults to just a "Policy OID broker", I want it to display something like this:  Unknown - 1234 ... Again, only for data that defaults to the "Policy OID broker"

I created a calculated column, and when I try to modify the dax to achieve what I want, I get an error.

 

Broker Name = IF(ISBLANK(TRIM(D_BROKER[BUSINESS_NAME])),IF(ISBLANK(TRIM(D_BROKER[PARTY_NAME])),"Unknown -  " & D_BROKER[POLICY_OID_BROKER],D_BROKER[PARTY_NAME]),D_BROKER[BUSINESS_NAME])
 
Can this be achieve with just a measure instead of creating a calculated column?
How can I fix my DAX to achieve that?
 
Thank You! 😄

 

 

question5.PNG

1 REPLY 1
Nathaniel_C Super Contributor
Super Contributor

Re: Concatenating a measure or field with a text

Hi @mvelazquez ,

Not sure if I understand exactly, but try this. When you go to a measure, unlike a calculated column, it does not have row contex. So in order to return a scalar value, it needs to be aggragated, MIN, MAX, SUM etc.  But when you apply it to a visual it is filtered by the visual, or by slicers, and they provide the filter context.

Broker Name = IF(ISBLANK(TRIM(MAX(D_BROKER[BUSINESS_NAME]))),IF(ISBLANK(TRIM(MAX((D_BROKER[PARTY_NAME]))),"Unknown -  " & MAX(D_BROKER[POLICY_OID_BROKER]),MAX(D_BROKER[PARTY_NAME])),MAX(D_BROKER[BUSINESS_NAME]))

 Let me know if this works for you, or if it does not, provide the error measure, please.
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (3,306)