Forum Discussion
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_YTD = SWITCH(SELECTEDVALUE('_PNL_Table'[REV&COGS]),
"COGS",[_YTD COGS],
"REV", [_YTD REV],
"OTH", [_YTD OTH],
"EXP", [_YTD EXP]
)
Can some one share with me where go wrong ?
Paul
5 Replies
Hi All
Below is my PBI sample file
Paul
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
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
Anonymous
When i click Step 2 , it select year = 2020 , Table 2 YTD expression display value is correct.When i click Step 1 , it select year = 2019 , Table 2 YTD expression display null. But Table 1 display there are value.
Below is my PBI file :-
https://www.dropbox.com/s/22lziixb1kx8nf2/APPEND%202%20GL%20INTO%201%20V006.pbix?dl=0
Paul Yeo
