Forum Discussion
mbudiman
Helper III
Helper IIIHide Measure column in Matrix that contains no value
hello, I have 2 tables, Fiscal_Qtr table and Sales Forecast table. Fiscal_Qtr table contains custom financial quarter period, where a field called Qtr_Sequence_No is used to define sequence of Quart...
You forgot to either expand or go into the next level in the hierarchy. If there isn't a single field of the display column parameter, SELECTEDVALUE returns blank so none in the switch conditions is met.
lbendlin
Super User
Super UserHow would that look like in the UI?
You could create a super measure (ie a reference table that lists all the measures, similar to what Field Parameters do) and then return BLANK() as needed which would hide those "columns" - but only if ALL cells are blank for that column/measure.