Forum Discussion
Stumped! Get Row Header Value
Good morning!
I took a look at the article...did not help. Because it's a date hierarchy, date is always being filtered so the ISFILTERED test is always true. Was thinking about it over the weekend, and decided to try the following and it worked exactly as intended.
Targets = IF( ISINSCOPE('Calendar'[Date]), BLANK(), IF( ISINSCOPE('Calendar'[MonthName]), SWITCH( TRUE(), AND( SELECTEDVALUE('Calendar'[Year]) = 2020, SELECTEDVALUE('Calendar'[MonthNumber]) = 4 ), 796, Etc...
But thank you for the suggestion!
HI littlemojopuppy,
I'd like to suggest you take a look at the following blog about hierarchy level handle on DAX formula:
Clever Hierarchy Handling in DAX
If above not help, please share some dummy data with a similar data structure to test.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
Good morning!
I took a look at the article...did not help. Because it's a date hierarchy, date is always being filtered so the ISFILTERED test is always true. Was thinking about it over the weekend, and decided to try the following and it worked exactly as intended.
Targets =
IF(
ISINSCOPE('Calendar'[Date]),
BLANK(),
IF(
ISINSCOPE('Calendar'[MonthName]),
SWITCH(
TRUE(),
AND(
SELECTEDVALUE('Calendar'[Year]) = 2020,
SELECTEDVALUE('Calendar'[MonthNumber]) = 4
), 796,
Etc...
But thank you for the suggestion!