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...
Need Help
  • 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 

lbendlin's avatar
lbendlin
Super User
4 years ago

Maybe you can show the data model and indicate where the offending column comes from in relation to the columns that are already in the visual.  Starts to sound more like a "simple" cartesian product.

 

You can use DAX Studio to look at the query plan before and after adding the column