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
Repeat Visuals Per Employee in Report
Is there away to repeat the same visualizations per employee in Power BI report? As an example, when the end user selects a department from a slicer, the employee list would change, but each employee would have the same set of 5 or so visualizations. Has anyone accomplished this if so how?
