Forum Discussion
Creating a dynamic summarized table or calculated table
OwenAuger , ImkeF , Anonymous, Sean
My understanding of the summarise function is to create a table based on certain groupings of source data. Therefore this becomes static. If I use filters and want to change the summary table it does not work.
My questions are
1) Is this achievable using DAX.
2) Is this acheivable using M Language ( power query) in which case how to pass the value of the selections in slicer to the query.
Appreciate all of your help.
Cheers
CheenuSing
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.
12 Replies
- I think you might be able to do it with DAX.
I would think that as soon as you try and pass values back to the Query Editor or M Language you would then have to refresh the data in order to see the changes. Hi Anonymous,
I have no idea if this is possible in DAX, as a slicer-selection returns a text which you would then have to pass "as a variable" to a DAX-expression.
This is possible in M (see the general concept here: http://www.thebiccountant.com/2017/03/22/use-slicers-for-query-parameters-in-powerbi/ ) but as GilbertQ already mentioned, that would mean that you have to hit the refresh manually after the slicer-selection has been changed. If that's OK for you & you need help in implementing it for your usecase, just let me know.
Cheers, Imke
