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 Expert
I understand there is a lot going on here, but any tips on how i could speed up running the following dax measure, in total i have three measure similiar to the example shown which according to DAX Studio take 94520 miliseconds to run.
NoRep = VAR __table = SUMMARIZE ( ALL ( PMS_COMPLAINT ), [Products] ) VAR __table1 = ADDCOLUMNS ( __table, "__p-value", CALCULATE ( [p-value], ALL ( PMS_COMPLAINT[PMSReportability] ) ), "__TAU", CALCULATE ( [TAU 1], ALL ( PMS_COMPLAINT[PMSReportability] ) ), "__trend", CALCULATE ( [__trend], ALL ( PMS_COMPLAINT[PMSReportability] ) ) ) VAR __table2 = FILTER ( __table1, [__trend] = "No Trend" ) VAR __table3 = GENERATE ( SELECTCOLUMNS ( __table2, "__Product", [Products] ), RELATEDTABLE ( PMS_COMPLAINT ) ) RETURN COUNTAX ( __table3, [PMSReportability] ) + 0
Solved! Go to Solution.
Hi @Anonymous ,
Sorry to reply late. I find that if you change your UR measure like below, it will change.
UR = VAR t = GENERATE ( SELECTCOLUMNS ( SUMMARIZE ( ALL ( Dim_PARTS ), [Product], "__p-value", CALCULATE ( [p-value], ALL ( Dim_Products[Reportability] ) ), "__TAU", CALCULATE ( [TAU 1], ALL ( Dim_Products[Reportability] ) ), "__trend", CALCULATE ( [__trend], ALL ( Dim_Products[Reportability] ) ) ), "_Product", [Product] ), RELATEDTABLE ( Dim_Products ) ) VAR t2 = FILTER ( t, [__trend] = "Up" ) RETURN COUNTAX ( t2, [PMSReportability] ) + 0
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Try this:
NoRep = VAR t = GENERATE ( SELECTCOLUMNS ( SUMMARIZE ( ALL ( PMS_COMPLAINT ), [Products], "__p-value", CALCULATE ( [p-value], ALL ( PMS_COMPLAINT[PMSReportability] ) ), "__TAU", CALCULATE ( [TAU 1], ALL ( PMS_COMPLAINT[PMSReportability] ) ), "__trend", CALCULATE ( [__trend], FILTER ( ALL ( PMS_COMPLAINT[PMSReportability] ), [__trend] = "No Trend" ) ) ), "_Product", [Products] ), RELATEDTABLE ( PMS_COMPLAINT ) ) RETURN COUNTAX ( t, [PMSReportability] ) + 0
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Firstly, thanks for the feedback, Icey
The data set is not filtering when selecting No Trend, and or up or down. just gives me the over total value for the data.
Hi @Anonymous ,
If you don't mind, please give me some data sample or create an example PBIX file.
Best Regards,
Icey
Hi @Anonymous ,
Sorry to reply late. I find that if you change your UR measure like below, it will change.
UR = VAR t = GENERATE ( SELECTCOLUMNS ( SUMMARIZE ( ALL ( Dim_PARTS ), [Product], "__p-value", CALCULATE ( [p-value], ALL ( Dim_Products[Reportability] ) ), "__TAU", CALCULATE ( [TAU 1], ALL ( Dim_Products[Reportability] ) ), "__trend", CALCULATE ( [__trend], ALL ( Dim_Products[Reportability] ) ) ), "_Product", [Product] ), RELATEDTABLE ( Dim_Products ) ) VAR t2 = FILTER ( t, [__trend] = "Up" ) RETURN COUNTAX ( t2, [PMSReportability] ) + 0
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |