Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
how to calculate and get percentages in a column?
can you write how to have be?
Try this out
2Sale2s =
VAR _total =
Calculate(
SUM('Planam'[Sales]),
Filter('Planam','Planam'[month] = Earlier('Planam'[month]))
)
var _val = 'Planam'[Sales]
return
_val/_total
or how can i multiply this? sales 2022 x %ct sales 2022
For any calculations you need to use calculated columns or measure
how to calculate measure? then for example, Sales 2022 value: cow is 544,385, and how to measure i can get percentage 43,06?
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
i get error: The SUM function only accepts a column reference as the argument number 1.
bad;/
You can also use the same DAX in order to create a measure
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
i cant use Sum, becouse is measure