dax average

I have the following table in Excel: DATE VALUE 1/1/2024 100.00 2/1/2024 150.00 3/1/2024 200.00 4/1/2024 5/1/2024 6/1/2024 7/1/2024 8/1/2024 9/1/2024 10/1/2024 11/1/2024 12/1/2024 Lets say this table is called Table1. For the Months 4/1/2024 - 12/1/2024...

I am creating a dashboard to display some calculated metrics. I have a detail with thousands of lines of submitted invoices. I have pulled out the Creation Dates, User, and the number of invoices submitted (by day and user), and I am trying to do some user level comparisons. I have been able to...

Hello Experts, I have been struggling for hours with different variations of this DAX formula in Power BI: Rank Shops = CALCULATE( RANKX( ALL(PDB[RM]), CALCULATE(AVERAGE(Shops[Report Total])), , ASC, Skip ), PDB[Simplified Portfolio] = "Stable" )...

Hi, I have the following workbook to get weighted student grade averages, which I am doing with `SUMX()` in DAX (From what I understand, this is akin to `SUMPRODUCT()` in Power Pivot): =SUMX(grades, [grade] * RELATED(weights[weight])) It's working pretty much as I want, except for the Grand...

Hi, I'm having a problem understanding what I'm doing wrong; I have a measure for Revenue; < SUMX(fTransactions, fTransactions[UnitsSold]*(1- fTransactions[Discount])*RELATED(dProduct[RetailPrice]) )...

I'm trying to calculate the daily average gas prices per month per Country. If I'd have the daily prices it wouldn't be a problem but I only have the prices for each Monday in each Country so I have to pretend that was the price for the whole week 'till the next Monday. The problem is I believe...

I ask to compute attrition rate from two different data sources. I have 2 different sources: 1st: employee headcount (one row per employee) which has all employee details such as Name, ID, Date of Joining, Supervisor name, Department etc. 2nd: showing data for employees who resigned I need...

Hello,I have a PowerPivot dataset for Football stats in which I have two measures created “RecYdsDomPct” and “RecTDDomPct” that I want to average together. The average of these should be 35.17%. However when I remove any of my other fields (day and game id) the percentages do not tie back to...

Is it possible to have an average measure summed in PowerPivot. I am rolling up timesheet data and subtracting the actual from the estimate for each feature then rolling that up to the release level. I am using PowerPivot measures to get the estimate and the actual. The estimate is an average...