Forum Discussion
Hoping
Helper III
Helper IIICreate Measure without altering context
I have a table - TABA which has a PERSON_ID, few other columns, INDICATOR column that has 2 values - YES and NO and an AMOUNT column. I have a table visual with PERSON_ID, all othercolumns and a...
If the measure doesn't return a value, even with the "+ 0" it means that Xiaoxin Sheng is right and you need additional (dimension) tables to force evaluation for every combination.
Note that I wouldn't necessarily add one table with each combination, but more likely dimension tables for PERSON, INDICATOR and CATEGORY.
sjoerdvn
Solution Sage
Solution SageTry adding "+ 0" to your measure.
HopingHelper III
Helper IIIThis didn't work. The measure never returns.
- sjoerdvn
If the measure doesn't return a value, even with the "+ 0" it means that Xiaoxin Sheng is right and you need additional (dimension) tables to force evaluation for every combination.
Note that I wouldn't necessarily add one table with each combination, but more likely dimension tables for PERSON, INDICATOR and CATEGORY.