measure

Here is a dummy dataset to illustrate my question: <colgroup><col><col><col></colgroup><tbody> Client_Ref Start_of_Payment Month Payment_Amount 101 01/01/2018 20 101 01/02/2018 20 101 01/03/2018 25 102 01/01/2018 15 102 01/02/2018 25 102 01/03/2018 10 </tbody> I am wondering if...

Hi folks, I am looking at some oat production data from the USDA. I have been able to compute yield (=Production/Harvest acres) using calculated fields and in PQ. It seems like I should be able to compute the yield using a measure, but I have been stumped. When I am in the measures dialog, I...

I am trying to make a measure that combines a starting budget and a revised budget to create a final budget. As an example of what I am looking for, some line items have a starting budget (say $200) and no revised budget ($0), so the final budget would be $200. Some line items had a starting...

Hello everyone, Below is a simplification of a pivvottable (OLAP!) I've created. I'm having trouble adding a column that shows the difference between the two periods I cannot use a calculated column because the source is OLAP/cube I cannot figure out how to use an MDX measure because there is...

Note: I recently posted my DAX Formula question at the Microsoft Power BI Forums (https://community.powerbi.com/t5/Forums/ct-p/Forums) and had a really bad experience (my post was marked as spam and I could not get help with the issue)... So I am going to try here at mrexcel.com, where I have...

Hi I am yet again stumped by a DAX measure. I am trying to create a measure of forecast over leadtime i.e. The cumulative forecast over the leadtime of the Product (which varies by product). The calculation works at the Product level but fails during aggregation. I cannot resolve how I use...

I'll be grateful for any assistance, I feel that I'm close to a solution, but need help in properly defining the measure [EffortAssigned] - either that or I'm trying to do something that is not possible. I apologize for the length of this post, but I hope I've described the situation clearly...

So I have just one table that I added to the data model, to give me some of the flexibility of dax and afford me some practice time. I have a measure that is a distinct count on my "sites" column, to count unique store numbers in my data set. I would like the measure to ignore the filter...

Hello, i have some data as below and i need to Multiply Completion% in status Report by Measure 1 but i found error as in measure 2 & measure 3 in measure 2 i have wrong grand total in measure 3 i have errors as in first 2 rows whats is the solution ?

Hi, Can someone please help me with the syntax to find the average of a measure using DISTINCTCOUNT. Here is the syntax of my measure: Number of Units = DISTINCTCOUNT( LoggedInData[Unit_ID] ) I was hoping I could just do something like this: Avg Number of Units =...

Hello I have a data model/PowerPivot, which I have been using for few months and all was working well until this morning. All of the sudden I have a number of measures that worked well last week but today come up with an error: "dependency error in the measure" even though I have not changed...

I have a brutally slow measure, and I need to create several more like it with contrasting logic in order to break down our spend in the categories a consultant is telling us to. Before I slow my model to a crawl I was hoping someone could help with optimization? Controlled PO no Pharmacy :=...

Hi can someone advise how to execute a calculation over a subset of rows only? In my case, I have a table that lists customers and their individual sales. I need a dynamic measure that loops over each customer, and adds their sales to give a total figure. Example - Customer, Sale, Total...

Hi, I have an issue with a DAX formula and have spent over a week trying to resolve it. I would like to know the number of sale transactions each day. But here’s the quandary: If the total number of units sold after returns is zero, ignore transaction. If total units sold is >0 then count it 1...

Hello, I need assistance creating a PY Revenue measure without a calendar table. Prior Year Revenue is the calculated measure I need to create. <tbody> Sales Year Revenue Account ID Prior Year Revenue 2017 $1234 11231 $36 2017 $123 213 $165 2017 $754 505 $1324 2017 $36 11231 0...

Does anyone have a template they use to measure or graphically represent a sales funnel?

Hi Boardies, So I've finally got the opportunity to mess around with DAX and some real-world data. I have a FACT table. DATE | SITE | PRODUCT | NET SALES and a Dimension Table that only contains unique values (These two tables are not related) PRODUCT I also have the following Measure...

Hello everyone, I have the following problem: I have twoinput sheets in Power Pivot, one for data in 2013 and one for data in 2015. Both sheets contain data for e.g. the retention rate of customers perproduct. Both data sets contain similar products. For data in table with 2013 data I...

Hi, I've created measure to calculate cumulative % which is based on 3 measures as shown below. However the result of the cumulative % does not look right (refer to image links below). Please note that the resulting image table in the links below shows 2 screenshots: one with negative values...

The following measure produces a different result depending on whether I use a machine with Excel 2013 or Excel 2016: =FIRSTNONBLANK(Russell_Group[Provider short name], IF( [Research Income (Total) £k] = CALCULATE([Benchmark (Research Income £k)], VALUES(...