Forum Discussion

admin11's avatar
admin11
Memorable Member
5 years ago

YTD expression return null value

Hi All   I Have below expression work fine , it return correct amount :-   SUM_YTD = SUMX('_PNL_Table','_PNL_Table'[Switch_YTD]).       But below expression display Null :-   Switch_Y...
Need Help
  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    admin11 , This seems like issue the way X function behaves

    I tried

    Measure = SELECTEDVALUE('_PNL_Table'[REV&COGS]) value is null when nothing is selected

    then I tried

    Measure = SUMX('_PNL_Table',[Measure] ), I am getting values

     

    Then I tried

    SUM_YTD = SUMX('_PNL_Table',SWITCH(SELECTEDVALUE('_PNL_Table'[REV&COGS]),
    "COGS",[_YTD COGS],
    "REV", [_YTD REV],
    "OTH", [_YTD OTH],
    "EXP", [_YTD EXP]
    ))

     

    This gives null like Switch_YTD

    • admin11's avatar
      admin11
      Memorable Member
      5 years ago

      amitchandak Kindly share PBI file , so i can figure out how you changes and make it work.

      Thank

      Paul

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    hi admin11 - The measure will calculate based on a particular value of GL type (COGS, EXP, OTH, REV) - hence you will have to add a slicer into your report for the same. Please see screenshot below for reference. 

     

     

    Attached is the updated pbix file. 

     

     

    Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue.

    Thanks!

    Sumanth