Running into an issue while i try to calculate a Sales percentage. Seem simple, but i am missing something here as my % values are showing 0.
My table contains different expenses and the Sales numbers in a table.
Need the visual to show the totals of expenses and the % of expense to the Sales
Calculated the measure to get the total of Sales
Sales = CALCULATE(SUM(‘Table’[Amount]),FILTER(‘Table’,‘Table’[Account] = “Sales”))
% of sales = divide([Total Amount],[Sales],0)
Both numerator & denominator are greater than 0. I tried changing to percentage but still show 0 for the calculation of 95325 / 616979 instaed of 0.15%