Behaviour of Calculate

[Anonymous]

Howdy All

Let say i have standard fact table as below

Category | Group | Group 2 | Value

C1 | G1 | F1 | 10
C2 | G1 | F1 | 10

... and so on

given i have parameter table based on unique value of Category, Group, Group 2

and i create a measure as such :

All_Value = 
VAR FilterCat = values(PARAM_CAT[Entry])

VAR FilterG1 = values(PARAM_G1[Entry])

VAR FilterG2 = values(PARAM_G2[Entry])

Return CALCULATE(SUM(FACT[Value]),FACT[Category] IN FilterCat, FACT[Group 1] IN FilterG1, FACT[Group 2] in FilterG2)

in which i have verified to be valid when i use the parameter in slicer or column header

Will below 2 measure show same result?

MeasureAlt1 = 

VAR FilterCat = values(PARAM_CAT[Entry])

VAR FilterG1 = values(PARAM_G1[Entry])

VAR FilterG2 = values(PARAM_G2[Entry])

Return CALCULATE(SUM(FACT[Value]),FACT[Category] IN FilterCat, FACT[Group 1] IN FilterG1, FACT[Group 2] in FilterG2, FACT[Group 2] IN {"F1","F2"})

MeasureAlt2 =

CALCULATE (All_Value,FACT[Group 2] IN {"F1","F2"})

Both are trying to add another filter from 

All_Value

which is 

[Group 2]

is IN 

{"F1","F2"}

with the first one replicate the whole DAX plus additional filter and the second only run calculate with the additional filter

I kinda need to create separate measure for some group for combining multiple measure in waterfall using disconnected table tricks.

Thanks

[v-piga-msft · Accepted solution]

Hi @Anonymous ,

By my tests based on your information, it seems that the two measures work as the same.

More details, please refer to my attachment.

Best  Regards,

Cherry

[Anonymous]

Thank you, seems like i could use this for tables with disconnected tables