Forum Discussion

trine_norris's avatar
trine_norris
Frequent Visitor
6 years ago

Create dynamic subset of data

Hi, 

 

I have a very large dataset (containing around 1 billion rows). Specific rows will be active based on several filters, causing the different rows to be dynamically active (by a key). I cannot apply them in an active relationship, as there are several filters making the selection.

 

The active dataset will always be around 14.000 rows (much better to work with). Is it possible to create a new dynamic table only with the active rows, that I can then apply dax to?

 

Thanks in advance!

 

My ques

dynamic table

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    Nope. You cannot create a model table that would be dynamic. Data is loaded at load-time and stays that way.

    Only visuals can be dynamic.

    Best
    D