Forum Discussion

Augustas-ase's avatar
Augustas-ase
Helper II
3 years ago

Formula

how to calculate and get percentages in a column?  
Need Help
darkinvader's avatar
darkinvader
Frequent Visitor
3 years ago

If you're already have measure for _sumOfSales  then just replace _sumOfSales  with your measure. Here in the above calculation "ALL" is playing the major role which will sum all the value regardless of the columns, so no need to worry about summing it.

  • Augustas-ase's avatar
    Augustas-ase
    Helper II
    3 years ago

    i cant use sum in the formula:

    var _sumOfSales = Sum(Test(Sales 2022) , becouse Sales 2022 is Measure, and i cant to choice it
    • darkinvader_'s avatar
      darkinvader_
      Resolver I
      3 years ago

      Hi Augustas-ase ,

      this what you can do I feel,

      % Sales = 
      var _sumOfSales = [Sales 2022]    <- your measure here.

      var _percent = Calculate(_sumOfSales,ALL(Table'Category))

       

      return

       

      _sumOfSales/_percent

      • Augustas-ase's avatar
        Augustas-ase
        Helper II
        3 years ago

        my formula: 

        % Sales =
        var _sumOfSales = [Sales 2022]
        var _percent = Calculate(_sumOfSales,ALL(SALES[big grupe])
        return
        _sumOfSales/_percent
         
        This is my formula, and i get error: The syntax for 'return' is incorrect. (DAX(var _sumOfSales = [Sales 2022] var _percent = Calculate(_sumOfSales,ALL(SALES[big grupe])return_sumOfSales/_percent)).