Which DAX formula should be used in Power Pivot to create a measure that calculates the average discount percentage for each region in a dataset containing columns such as Date, Region, Sales, and Discount for 3 months, while excluding sales with a discount percentage of zero?

act as an experiences Power BI developer and give me DAX code to compute total sales for selected regions

How would you calculate the running total of sales amounts over time using DAX in Power BI? Use the CALCULATE function to calculate the running total Apply a filter to calculate the running total Define a relationship between tables to calculate the running total Use the SUM function to calculate the running total

Sophie is working on sales data from her company and wishes to see what the total profits were for each Region, on each month. What PivotTable would she draw? 0 / 1 pointThe PivotTable would have: Months as Values, Profits as Columns, and Profits as Rows.The PivotTable would have: Region as Values, Months as Columns, and Profits as Rows.The PivotTable would have: Profits as Values, Region as Columns, and Months as Rows.The PivotTable would have: Region as Values, Profits as Columns, and Months as Rows.

Calculations on pivot table in HR analytics dataset - Data Analysis in Excel, Aggregating and Summarizing Data in Pivot tables - Post ClassGiven an Employees dataset, there are different categories for people who are required to travel as part of their job, your task is to find the following insights for each category in order to reconsider budget allocation.Tasks1.Find the percentage of employees from each department using pivot table in the cells B2:B5 in sheet named Pivot

New measure (DAX Function) is generally used to create an aggregate level calculation.*TrueFalse