Filter ALL

[dfs29]

Hello, 

I have a problem : 

I created a measure with calculate and all like this :

" _test = CALCULATE([_Total (hm)],ALL('cache Activite_Hiera'[tact_code])) "

But the result is not what I want ....  because I would like to have 498:15:00 for each rows of _test column and not the same result that my column "total(hm)"

[dfs29]

Is there anyone to help me please ?

[aj1973]

If you share a sample of your PBIX

[dfs29]

@aj1973 

this the first exemple with 

_test = CALCULATE([_HM],ALL('cache Activite_Hiera'[CO]) )

And my second exemple with your suggestion 

_test = CALCULATE([_HM],ALL() )

And I would like to have the same number of the column_HM in _test 

So who can help me pleaseee 

Best regards 

[v-easonf-msft · Accepted solution]

Hi, @dfs29 

Plesase try measure formula like:

_test =
SUMX ( VALUES ( 'cache Activite_Hiera'[CO] ), [_Total (hm)] )

Best Regards,
Community Support Team _ Eason

[dfs29]

I tried but I don't have the result that I want because I would like to have 498:15:00 but with your suggestion I have the sum of all my data....

[aj1973]

Hi @dfs29 

try this

 _test = CALCULATE([_Total (hm)],ALL())