Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Memory Usage spikes when adding dimension column to table visual

Hi all,   I have a table with 2,3million rows and a many-to-one relationship with a dimension table (dimension: one, fact table: many).    I created a table visual with columns from the fact tabl...
  • Anonymous's avatar
    Anonymous
    4 years ago

    The problem was four columns which were basically place-holders. Three columns should have headers but no entries (blank) and one column should have a header but all entries should say FALSE. In order to do that, I created three blank measures and one false measure. When I add a single blank measure as a column, then the visual shows no rows anymore. However, when I add the false measure as a column then it shows all rows again. Pretty strange behaviour as far as I can see. Would be nice to be able to create measures rather than calculated columns for this purpose but the loading times are just too long. Without the blanks and false column the visual loads in no time just as expected. 

     

    Thanks for the suppoert lbendlin