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 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
Helper I
3 years ago

Is there anyone to help me please ?

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 

     

    • v-easonf-msft's avatar
      v-easonf-msft
      Community Support
      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