Create dynamic subset of data

[trine_norris]

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

[Anonymous]

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