Help - DAX Measure for Dynamic Chart Title with DrillDown

[bboobe]

Dear Experts, 

I am trying to create the below measure but it is not working.

Measure - 

      Test Chart Title =

               Var MonthPart = SELECTEDVALUE('Time Day'[Month_Year],"Current Month")

               Var Geography = IF(

                   ISFILTERED('PS Location'[COUNTRY],

                   SELECTEDVALUE('PS Location'[COUNTRY]), "" )

      return

"Country Wise" & Geography & MonthPart

     

Geography is not returned in this measure. Please help.

[nandukrishnavs · Accepted solution]

@bboobe 

Try this 

Test Chart Title =
VAR MonthPart =
    SELECTEDVALUE (
        'Time Day'[Month_Year],
        "Current Month"
    )
VAR Geography =
    IF (
        ISFILTERED ( 'PS Location'[COUNTRY] ),
        SELECTEDVALUE ( 'PS Location'[COUNTRY] ),
        ""
    )
RETURN
    "Country Wise" & Geography & MonthPart

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂

[bboobe]

@nandukrishnavs  It Worked!! Awesome, Thanks!