Forum Discussion
Solved
Summarize text in rollup matrix
Hi, I have a measure that forecasts when a task is going to be due and displays "HRS" if that is when it will be due based off hours accumulated or CF if it is on the capital forecast for that pe...
Thank you for your reply. I ended up using the following measure which references my original measure to achieve the desired result
SWITCH(IF(ISINSCOPE(TRACKED_COMP_LIST[TYPE]),[FORECAST_COMBINED],"NO"),"NO",0,[FORECAST_COMBINED])This returns 0 for any level that is above the desired level and then I applied a conditional formatting to make all 0 values transparent text.
v-easonf-msft
Community Support
Community SupportHi， WNAGGE
You can consider using function ISINSCOPE to shows the values for each level based on your custom calculation.
Use IsInScope to get the right hierarchy level in DAX
Best Regards,
Community Support Team _ Eason
Thank you for your reply. I ended up using the following measure which references my original measure to achieve the desired result
SWITCH(IF(ISINSCOPE(TRACKED_COMP_LIST[TYPE]),[FORECAST_COMBINED],"NO"),"NO",0,[FORECAST_COMBINED])
This returns 0 for any level that is above the desired level and then I applied a conditional formatting to make all 0 values transparent text.