Formula

[Augustas-ase]

how to calculate and get percentages in a column?

[Augustas-ase]

can you write how to have be?

[BIswajit_Das]

Try this out
2Sale2s =
VAR _total =

Calculate(

SUM('Planam'[Sales]),
Filter('Planam','Planam'[month] = Earlier('Planam'[month]))

)

var _val = 'Planam'[Sales]
return
_val/_total

[Augustas-ase]

or how can i multiply this? sales 2022 x %ct sales 2022 

[BIswajit_Das]

For any calculations you need to use calculated columns or measure

[Augustas-ase]

how to calculate measure? then for example, Sales 2022 value: cow is 544,385, and how to measure i can get percentage 43,06?

[BIswajit_Das]

You got a column sales 2022 with value 544,385
Then you have a create an other calculated column for to get 43.06%
Formula for the column is :-
#column =
VAR _total = SUM([Sales 2022])
VAR _val = [Sales 2022]
RETURN
ROUND((_val / _total)*100,2)
then later you can use the #column For other calculations

[Augustas-ase]

i get error: The SUM function only accepts a column reference as the argument number 1.

[Augustas-ase]

bad;/

[BIswajit_Das]

You can also use the same DAX in order to create a measure

[darkinvader_]

Hi @Augustas-ase 

So let me assume "Category" is the only column on your table visual and "Sales" is the factuals.

DAX formula below:

% Sales = 
var _sumOfSales = Sum(Table'Sales')

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

return

_sumOfSales/_percent

(put your columns accordingly and change the data presentation to %)

Please do hit like if this provides you with a solution

Regards

darkinvader

[Augustas-ase]

i cant use Sum, becouse is measure