Forum Discussion

bboobe's avatar
bboobe
Icon for Helper I rankHelper I
6 years ago
Solved

Help - DAX Measure for Dynamic Chart Title with DrillDown

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.

chart
DAX BUG
measure based on slicer
title
  • nandukrishnavs's avatar
    nandukrishnavs
    6 years ago

    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     🙂

2 Replies

  • nandukrishnavs's avatar
    nandukrishnavs
    Icon for Community Champion rankCommunity Champion
    6 years ago

    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     🙂