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?
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