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 Experts
is it possible to move the following measure __S (as shown below) to the power query side. i believe this major a offender as It is a SUMX of ADDCOLUMNS of a SUMX of ADDCOLUMNS which is dependent on an EARLIER conditional. This particular set of functions are going to result in multiple full table scans in a recursive scenario. Is there any way that these functions can be either simplified or pre-calculated on the Power Query side
Hard to say with the information provided, not sure what this is used for or how it is used. Probably easier to make it a DAX column than port it to Power Query. That would solve the report performance problems.
Hi greg
this is the measure you tweaked for me some time back (mann kandell) analysis (way back last year october 2019. in total i have 5 measure that link together in order to calculate the p-value..
Hmm, I will have to look at what an become columns in all of that. This was during my flurry of fascination with measures. I have since come to realize the wisdom of columns.
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 |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |