Forum Discussion
Augustas-ase
Helper II
Helper IIFormula
how to calculate and get percentages in a column?
Augustas-aseHelper II
Helper IIi cant use sum in the formula:
var _sumOfSales = Sum(Test(Sales 2022) , becouse Sales 2022 is Measure, and i cant to choice it
darkinvader_
Resolver I
Resolver IHi 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/_percentThis 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)).