Formula

[Augustas-ase]

how to calculate and get percentages in a column?

[darkinvader]

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]

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_]

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]

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

[BIswajit_Das]

Hello @Augustas-ase

If you want to view percentage on the matrix visual then you can also do this

[Augustas-ase]

its cool, but how to get this in measure? 

i want to multiply it with forx example:  sales * %gt sum .....

[Augustas-ase]

and how to get a new measure with %??

[BIswajit_Das]

Hello @Augustas-ase here's something that may be helpfull

[Augustas-ase]

all i get 100%

[Augustas-ase]

how to make, for example, that '2sale2s2' is calculated for each month 100% for each month, instead of for the whole year

[BIswajit_Das]

Hello @Augustas-ase, So you want the percentage to calculated by each month!!!

[Augustas-ase]

yes

[BIswajit_Das]

You can do that by
Modify your formula to
calculate (

expression,
filter(table,table[monthcol] = eariler(table[monthcol]))
)

[Augustas-ase]

what should it look like when you put it in this formula?

Sales =

VAR _total = sum('Planam'[Sales 2022])

return

_total

[BIswajit_Das]

Sales =
VAR _total =
Calculate(

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

)
RETURN _total
try this out

[Augustas-ase]

maybe you know, how to write formula, then my data is in table for example: 

a result I get Sales 2022 using a different formula  %CT Sales 2022  this this column comes from SALES 2022

how do I get the measure so I can use it for other calculations?

[BIswajit_Das]

You can use that column values as mesure values and can use it in other visuals.

[Augustas-ase]

but I want to get a separate percentage formula, make a new measure

[v-jingzhang]

Hi @Augustas-ase 

Have you solved this problem? If yes, you can accept an appropriate reply as solution or post your own solution. If not, you may refer to my sample file attached at bottom. Usually providing some sample data or sample file will make other users understand your data and expected result better. 

If you have a column [Sales] in table 'Table', you can try a measure like below. 

% of Sales = DIVIDE(SUM('Table'[Sales]),CALCULATE(SUM('Table'[Sales]),ALL('Table')))

If you already have a measure like [Sales Measure] which calculates the sum, you can create a new measure like 

% of Sales 2 = DIVIDE([Sales Measure],CALCULATE([Sales Measure],ALL('Table')))

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[Augustas-ase]

2Sale2s =

VAR _total = sum('Planam'[Sales])

var _val = 'Planam'[Sales]

return

_val/_total

should also be added here