Forum Discussion
Creating a dynamic summarized table or calculated table
Here is the link to the file: https://1drv.ms/u/s!Av_aAl3fXRbehap3IIpK9lEWhPkdwA
When you change the slicer-selections, the Table1 will change it's columns accordingly - after you've hit refresh!
When you apply it to your model, you might find that it doesn't work at the first go. Don't know why that is, but the solution is to close the file and re-open it. At least, this worked for me :-)
Edit: Changed link to the file: The measure that harvests the slicer-selection must be used in the report somewhere.
Hi Anonymous
We would need a working example to understand what you are trying to achieve.
I would imagine that the data would be loaded into a summarized table using the new table functionality, and then I would use DAX to create dynamic measures based off that table. I have done something similar in the past for a bit of a complex maths calculation. Unfortunately I cannot share that information. But it was so that I could have a line going across the data, and if they selected more or less years, the line would then change to reflect this.
Hi GilbertQ
I want to build the reduced dynamic data set using summarise function . I know about creating measures dynamically. I am interested in the reduced dynamic data set based on filters selected.
Cheers
CheenuSing
- Ok thanks I think that you will have to see what Imke can come up with her amazing skills. I can only think that once you have loaded the data you cannot filter it in terms of reducing the size without having to reload the data.
Here is the link to the file: https://1drv.ms/u/s!Av_aAl3fXRbehap3IIpK9lEWhPkdwA
When you change the slicer-selections, the Table1 will change it's columns accordingly - after you've hit refresh!
When you apply it to your model, you might find that it doesn't work at the first go. Don't know why that is, but the solution is to close the file and re-open it. At least, this worked for me :-)
Edit: Changed link to the file: The measure that harvests the slicer-selection must be used in the report somewhere.
Hi ImkeF
Thanks. The only caveat is we will have to refresh for every change in the selection.
I will try it. Your source data can that be given in excel for me to play around.
Cheers
CheenuSing