Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
@OwenAuger , @ImkeF , @Seth_C_Bauer, @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
Solved! Go to Solution.
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.
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Hi @CheenuSing,
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
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Hi @CheenuSing
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
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.
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Hi @ImkeF,
Can you explain step by step how your solution should work ?
Does it alwayes need to connect with Analysis Services?
Regards,
Paweł
Hi @paweldm,
yes, this solution only works via the connection to the Analysis server instance. So it will NOT work in the service in PowerBI.com.
Currently I cannot see which steps are missing in the documenation (mine and Rob Collie's blogpost). What exactly are you missing?
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
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
is there any workaround to avoid refreshing
Will do tomorrow if no DAX-solution shows up until then 🙂
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |