Measure or table

[phaum1967]

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 

[Eric_Zhang]

---

@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 

---

@phaum1967

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] )

[Anonymous]

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.