Forum Discussion

dfs29's avatar
dfs29
Helper I
3 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 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)"

 

 

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

6 Replies

  • dfs29's avatar
    dfs29
    Helper I
    3 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....

     

     

    • aj1973's avatar
      aj1973
      Community Champion
      3 years ago

      If you share a sample of your PBIX

      • dfs29's avatar
        dfs29
        Helper I
        3 years ago

        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