How to create a dynamic generate series

Question

I have a table that is created by the following DAX:

Top = GENERATESERIES(1; DISTINCTCOUNT(Sales[Id_Salesperson]); 1)

So far, the table is created with 248 rows, but when I select a month, I dont have 248 salesperson, just 50 for example in the selected month, then, I need to create a dynamic generate series that returns to me the DISTINCTCOUNT of ID_Salesperson and suffer the action of filters.

I'm creating a calculated table with generate series because I'm using this on a slicer to filter a table with a measure.

Is it possible?

gluizqueiroz · Answer

Hey&nbsp;v-yuta-msft.Yes, I can.For example, I have the following table:&nbsp;And I create a calculated table named "Top", like the following:&nbsp;&nbsp;For example, I have the following visual:&nbsp;My problem is: I have just 1 salesperson with sales on "October", if I select the Month October, I have the following result:&nbsp;As you can see, the measure "DistinctCount of column Salesperson..." show me the value 1, and that is correct, I have only 1 salesperson with sales on October, but the "Count of Table "Top" and the Table "Top" continue showing 4, but I selected October, that correct value is 1.&nbsp;The Table "Top" was created by this DAX: GENERATESERIES(1; DISTINCTCOUNT(Sales[Salesperson]); 1),&nbsp;like the measure "DistinctCount of column Salesperson..." but the calculated table doesn't suffer the action of filter like measure suffer.&nbsp;Is it possible do something about dyamic calculated table, in other words, the table is calculated/created like a measure?&nbsp;I use the column "Top" from table "Table" on a slicer.

greg_deckler · Answer

Not with a calculated table, you would have to use a pure measure to make it dynamic.

gluizqueiroz · Answer

I use the previous slicer to show X salesperson on a table. If the user select 248 on slicer, the table will show 248 salesperson, if he choose 10 on slicer, the table will show 10 salesperson.
This values on slicer is a column from "Table" named Top that I mentioned before and this valeus is genereted by GENERATESERIES,

You tell me that I can't do this with calculated table, just pure measure, but how can I put a measure on a slicer to filter the table?
I create a calculated table because I just can filter with "real" values, in other words, I just can filter (put on slicer) values that came from table, not measure.

I think it is impossible achieve my goal, am I right?

Thanks for help Greg.

v-yuta-msft · Answer

gluizqueiroz,
&nbsp;
I use the previous slicer to show X salesperson on a table. If the user select 248 on slicer, the table will show 248 salesperson, if he choose 10 on slicer, the table will show 10 salesperson.This values on slicer is a column from "Table" named Top that I mentioned before and this valeus is genereted by GENERATESERIES,You tell me that I can't do this with calculated table, just pure measure, but how can I put a measure on a slicer to filter the table?&nbsp;I create a calculated table because I just can filter with "real" values, in other words, I just can filter (put on slicer) values that came from table, not measure.
Could share some sample data and give expected result?
&nbsp;
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

anonymous · Answer

Hello,I have been struggling with the same problem for days. Is there any solution for this? BTW, I believe this might be solved by creating a relation between tables but I do not know how to create such a relation since I need to filter my range slicer by the date selection.Cheers!

Forum Discussion

How to create a dynamic generate series

5 Replies

Related content

Lakehouse Table Generate Create Table

Creating a dynamic slicer

Generating Missing Data

Dynamically Generated Queries

Generate some views create script