topic Re: Create table from another with a dynamic variable in Desktop

Create table from another with a dynamic variable

Syndicate_Admin — Thu, 30 Mar 2023 13:24:22 GMT

Good morning, I would like to guide me how to create a table from another with filter but the new table has a dynamic variable in the filter.

I attach the following example:

I have a table with sales fields, months and years. The report shows me the table with the fields described with a segmentation of years. The measure [annio] captures the selected year value.
And I want to get a new table according to:

Tabla_Filtro_medida =

var aniio = [annio]

var table = filter(Sales, Sales[Year]=aniio)

return table

where [annio] = SELECTEDVALUE(Sales[Year])

however the table comes out blank

If I change the variable aniio by a constant number, there if I get the table ... for example create the tabla_Filtro_valor according to

Tabla_Filtro_valor = filter(Sales, Sales[Year]=2010)

As you will see, the problem is just in the dynamic variable. How can I make it work.? ..... Note that the objective is to create the table so that the variable is dynamic.

Thank you very much for your help.

Best regards

Juan Suyon

Re: Create table from another with a dynamic variable

Syndicate_Admin — Sat, 01 Apr 2023 13:52:14 GMT

Good day, any suggestions or opinions if you can or not?

Thank you

Juan Suyon

Re: Create table from another with a dynamic variable

lbendlin — Sat, 01 Apr 2023 16:33:36 GMT

You cannot create a calculated column or calculated table from a measure.

Re: Create table from another with a dynamic variable

Syndicate_Admin — Sat, 01 Apr 2023 19:06:18 GMT

OK, thanks!!! .... Consultation, how could I do it otherwise, that is, what option would there be?

Thank you!

JUan Suyon

Re: Create table from another with a dynamic variable

lbendlin — Sat, 01 Apr 2023 23:43:57 GMT

What are you planning to do with that resulting table?

Re: Create table from another with a dynamic variable

Syndicate_Admin — Sun, 02 Apr 2023 00:43:51 GMT

Hello, I plan to apply the Topn function

Thank you

Best regards

Re: Create table from another with a dynamic variable

lbendlin — Sun, 02 Apr 2023 01:05:41 GMT

I meant: What business question are you trying to answer?

Re: Create table from another with a dynamic variable

Syndicate_Admin — Sun, 02 Apr 2023 01:32:21 GMT

I explain the problem..... I have a multi-year sales table from different clients...... I want to get the top 20 sales per customer dynamically.... that is, with a year filter that shows me the table of the first 20 cleintes for that year. As the year is in a segmentation, the idea is to obtain this table every time the year varies.

That's why I tried to create the table with the dynamic variable but I understand that you can't..... Would there be another way to get what I am looking for dynamically?

Thank you

Re: Create table from another with a dynamic variable

lbendlin — Sun, 02 Apr 2023 02:04:50 GMT

You do that via RANKX() and then TOPN(20,...)

Re: Create table from another with a dynamic variable

Syndicate_Admin — Sun, 02 Apr 2023 03:21:53 GMT

Thanks a lot!