Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi @JBaker0585 ,
If I should guess, it's not the SUMMARIZE-function which slows down your query, but the MEDIANX-function probably does. MEDIANX is an iterator function.
What is the purpose of the ALLSELECTED-function?
If you post a sample of your report, I can try to tune it.
Cheers,
Sturla
Thanks, @sturlaws. The ALLSELECTED was used in another piece of DAX that I modified for my particular solution. I have not attempted the code without it.
For my sample data, what exactly would you need to help you set up a test?
User | Count |
---|---|
47 | |
27 | |
23 | |
18 | |
15 |
User | Count |
---|---|
55 | |
34 | |
18 | |
17 | |
15 |