Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Thanks a lot!
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
You do that via RANKX() and then TOPN(20,...)
OK, thanks!!! .... Consultation, how could I do it otherwise, that is, what option would there be?
Thank you!
JUan Suyon
What are you planning to do with that resulting table?
Hello, I plan to apply the Topn function
Thank you
Best regards
I meant: What business question are you trying to answer?
You cannot create a calculated column or calculated table from a measure.
Good day, any suggestions or opinions if you can or not?
Thank you
Juan Suyon
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
105 | |
86 | |
73 | |
66 |
User | Count |
---|---|
124 | |
113 | |
98 | |
81 | |
72 |