Forum Discussion

dfs29's avatar
dfs29
Icon for Helper I rankHelper I
4 years ago
Solved

Filter ALL

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 w...
Need Help
Tips and Tricks
  • v-easonf-msft's avatar
    v-easonf-msft
    3 years ago

    Hi, dfs29 

    Plesase try measure formula like:

     

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

     

    Best Regards,
    Community Support Team _ Eason

dfs29's avatar
dfs29
Icon for Helper I rankHelper I
4 years ago

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....