Forum Discussion
Solved
Create 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.
Try adding "+ 0" to your measure.
This didn't work. The measure never returns.
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.
