'How to calculate % in sales when we calculate sales amount in measures?
If sales and profit amount presents in row by row then it would easy to calculate % of sales.
% of Total Sales = VAR Allsales = CALCULATE( Orders[ALL Total Sales], ALL(Orders) ) VAR Ratio = DIVIDE([Total Sales], Allsales) RETURN RATIO
and then I created another sales amount by using measures like this Sales Amount = CALCULATE(SUMX( 'Sales by Store', 'Sales by Store'[quantity_sold] * 'Sales by Store'[unit_price]))
and when I create % of sales I am unable to divide the sales / all sales * 100 pls help me out [enter image description here][1]
% of Total Sales = VAR Allsales = CALCULATE('Sales by Store'[Sales Amount])
VAR Ratio = DIVIDE('Sales by Store'[Sales Amount],Allsales) RETURN RATIO
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
