Create dynamic subset of data

trine_norris — Thu, 19 Mar 2020 11:30:54 GMT

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

Re: Create dynamic subset of data

Anonymous — Sat, 21 Mar 2020 13:07:04 GMT

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

topic Create dynamic subset of data in DAX Commands and Tips

Create dynamic subset of data

Re: Create dynamic subset of data