Forum Discussion
Formula
how to calculate and get percentages in a column?
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
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)).