Forum Discussion
Formula
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?
You can use that column values as mesure values and can use it in other visuals.
but I want to get a separate percentage formula, make a new measure
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.
