Forum Discussion
4 Replies
- wallingfordceData Pipeline
Hi TomerA -
Sisense requires that either all main table values exist in the other table, or you need to create an intermediary/bridge table with all distinct values from the main table left joined to the other table, and a null replacement for the main table values that don't exist in the other table.
- TomerACloud Apps
Thanks, I thought there way to avoid this.
To solve this I created a custom column with relevant missing data in the main table.
- harikm007Data Warehouse
Hi TomerA ,
I think the best method is updating the data model. But you can do it by using 'ALL' function in formula.
For example, if you have 2 tables - Table1 and Table2. Table1 is a DIM table which contains 5 Names and their IDs. Table2 is a transaction table which contains only 3 Names. Tables are connected using Name field. Below is the formula to display Id from DIM table, Name from DIM table, Sum of values from transaction table.
case when (sum([Value]), all([Name]), all([id])) > 0 then (sum([Value])) else 0 end
In summary you need to use 'ALL' function with all fields from DIM table that are used in pivot table.
Please refer screenshots.
- TomerACloud Apps
Hi, Thanks for the reply. Unfortunately the column I add is Row and not Value so I cannot use formulas.