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 Users
I'm wondering if it is better to create a complex measure or to create some tables to divide a complex problem in understandable parts ?
Is someone can share his experience.
I tried to do some complex dax formula but as i m not a pro, understanding each step with a summarize table seems to me better...
thanks
@phaum1967 wrote:
Hi Users
I'm wondering if it is better to create a complex measure or to create some tables to divide a complex problem in understandable parts ?
Is someone can share his experience.
I tried to do some complex dax formula but as i m not a pro, understanding each step with a summarize table seems to me better...
thanks
For complex dax formula, you could try to use VAR. eg in this thread
Top3ofAnySelectedCountry = VAR TBL = SUMMARIZE ( Data, Data[Country], "sumtotal", SUM ( Data[Amount] ) ) VAR RNK_TBL = ADDCOLUMNS ( TBL, "RANK", RANKX ( TBL, [sumtotal],, DESC, DENSE ) ) RETURN SUMX ( FILTER ( RNK_TBL, [RANK] <= 3 ), [sumtotal] )
I'd say it depends on the situation, but generally for very complex measures involving summary tables, I'll use DAX Studio to test steps and view the summary tables and make sure everything works the way I expect along the way before completing the measure. I don't like to keep extra tables around in memory if I don't have to. Bogs everything down.
Proud to be a Super User!
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 |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |