Dynamic Title based on drillthrough

[jostnachs]

Hi, I have a dax written for dynamic title based on drill through selection. But it gives me correct title when the selected value has more than one client but giving me client name only instead of selected parameter name if the value has only one clinet.

Client Detail Title1 =

VAR carrierselected = SELECTEDVALUE(V_CompanyIssuing[Issuing Company])

VAR clientselected = SELECTEDVALUE(V_DimClient[ClientName])

VAR PayeeSelected = SELECTEDVALUE(V_CompanyBilling[Billing Company])

RETURN

IF(

NOT ISBLANK (clientselected),"Client Detail - " & clientselected,

IF (

NOT ISBLANK(carrierselected), "Client Detail - " & carrierselected,

IF (

NOT ISBLANK(PayeeSelected), "Client Detail - " & PayeeSelected,

    "ALL"

)

)

)

Can someone help me

[Anonymous]

Hi @jostnachs ,

Can you please share some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng