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