need to repeat same measure value to use as denominator, % of sales calculation based on measure val
Total Revenue line = CALCULATE([Actuals CM],FILTER(Layout,Layout[Level 2]="TOTAL REVENUE")) -881495.70 Actuals CM = COALESCE([actuals month],[item SUBTOTAL]) new measure = DIVIDE([Actuals CM],[Total Revenue line]) Hello All, reaching to all my power BI senseis regarding an issue that i am having with a measure. I am looking to divide all the actuals for current month (Actuals CM) by the total revenue line for the month (total revenue line) in order to get a % of revenue measure for all items. I tried the to create a measure (new measure) and it works but only for 3 rows. The revenue, TOTAL Revenue, and Total lines. I am guessing because the value of -881,945.70 is not repeating down to all rows. how can I have all rows repeat the total revenue line figure or achieve the calculation for all rows to divide by this value? Thank you for your assistance
