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.
Hello Friends
Despite my attempts to address the issue, I need to input text into the "Metrics" table in the Matrix, but there is no corresponding column in my database. I don't have a metrics column also I want to assign them with corresponding values
matrix