Forum Discussion
Formula
what should it look like when you put it in this formula?
Sales =
VAR _total =
Calculate(
SUM('Planam'[Sales 2022]),
Filter('Planam','Planam'[month] = Earlier('Planam'[month]))
)
RETURN _total
try this out
- Augustas-ase3 years agoHelper II2Sale2s =VAR _total = sum('Planam'[Sales])var _val = 'Planam'[Sales]return_val/_totalshould also be added here
- Augustas-ase3 years agoHelper II
can you write how to have be?
- BIswajit_Das3 years agoImpactful Individual
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-ase3 years agoHelper II
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_Das3 years agoImpactful Individual
You can use that column values as mesure values and can use it in other visuals.
- Augustas-ase3 years agoHelper II
but I want to get a separate percentage formula, make a new measure
- v-jingzhang3 years agoCommunity Support
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.