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.
Hi, I would like to know if I can create a dynamic table in Power BI based on a report filter?
I am trying to write this query:
SummaryTable = CALCULATETABLE(SUMMARIZE('Sheet1','Sheet1'[team_ID]), FILTER('Sheet1', SELECTEDVALUE(Sheet1[team_ID])))
But it doesn't work. The SELECTEDVALUE() works fine for measures, but not at all for table creation or a role creation for RLS.
Please help.
Solved! Go to Solution.
Hi @pji,
Not like measures, calculate columns/tables are computed during database processing(e.g. data refresh) and then stored in the model, they do not response to user selections(or other filters) on the report.
So it is not possible to create a calculate column/table that can change dynamically with user selections(or other filters) on the report.
Regards
Do you know if there is any possibility to create a matrix table with dinamic number of coordenates? I have tried to created a calculated table with GENERATEALL and GENERATESERIES, but as calculated table can be use with HASONFILTER it is not working? I'm a little lost on how to do it?
Thanks
Hi @pji,
Not like measures, calculate columns/tables are computed during database processing(e.g. data refresh) and then stored in the model, they do not response to user selections(or other filters) on the report.
So it is not possible to create a calculate column/table that can change dynamically with user selections(or other filters) on the report.
Regards
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |