measures

I've come across a strange behaviour of Power Pivot related to measures on fields of detail tables. I have the following simple model: Grades (Grade code, Target Utilization) Team (Name, Grade code) <links to the Grades on Grade Code> Forecast (Name, Period, value, MaxValue) <links to Team on...

Hello everyone! I have a data source that consist of multiple tables with different relationship. I'm trying to achieve a calculated measure that uses 3 other measures that comes from different tables. I'm trying to create a measure that looks like this, Overall Yield = 'A Yield'[Yield A...

Hello, I have created pivot tables (including measures from Power Pivot) and added some slicers, but for some reason one of them still keeps returning all of the possible results and just shows 100%. Any ideas why? See screenshot below:

Hi all, I have 5 KPIs created in measures that I want to get a total value for, I've google it all and the best option i can find is : =[Accident KPI Score] + [Site Inspection KPI Score] + [Site Returns KPI Score] + [Operational RA KPI Score] + [NC Target Date Met KPI Score] however this...

Hello experts, In my Power BI report I am trying to do a calculation on all rows in a table, then be able to correctly add them up in the subtotal lines by whatever grouping I am using. In my case, the final grouping I have in Matrix rows is 'Calendar'[EOM], which is not being used in the...

Hi, I have many tables and I would like to find out the best way to count the number of units sold that meet a criteria. In tblInvMaster I have a fields called PROMO CODE. I want to sum up the number of units from tblSALE that have a PROMO CODE. So I can use the related function in DAX...

I would like to create a series of measures that shows my current week's sales by day. Example: 1 measure shows Sunday's sales, 1 measure shows Monday's sales, etc. In order to identify the current week, I have added a field to my date table called 'Week Rank' in combination with the max...

Hi Everyone, I am currently making a daily store sales table and am having trouble adding 2 measures that I created (previous week's sales and % change). The issue I am having is when I drop the 2 measures into my matrix, the format changes to something completely unusable. See below. Also, I...

Hi, I'm struggling to get this to work, any solutions would be much appreciated. - data shows forecasted and actual sales for the year. - data has two date cells, 'projected close date' and 'actual close date'. i.e. when we think it's going to land and when it actually landed. - want to create...

I have a Cost file in my data model that has costs in it for different times - Last Year, This Year. I have a measure Difference Last Year - This Year = Calculate (Sum ('Cost File'[Last Year],'Cost File'[Period] in {"Last Year"})-Calculate (Sum ('Cost File'[Last Year],'Cost File'[Period] in...

Hello everyone. I'm not good at explaining stuff, but I'll give it a ago, since I'm stuck - I've included pictures, since it's troublesome to describe in text - I hope that's okay :) I have a data-sheet, from which I've created the pivot table shown below, displaying amongst other things...

I am struggling to set up a measure in Excel to look up a text value from a dimension table based on a key in a fact table. I am using Power Query to import tables from a variety of data sources as connections, so there is no literal table in the spreadsheet. My fact table is CourseCompletions...

Hi, I've created various measures to help try and show a baseline plan of implementation versus actual, which works as expected when there's no filters applied. However, when I apply a filter, none of the measures update and instead continue to show the full, 'unfiltered', values. I have tried...

Hello, I'm looking for some guidance with if and how I could use measures to help me create some enhanced pivot tables. I have detailed a couple of specific questions in the document here (in red text in the Sheet: Pivot Test): s666-PQ-Impact system 2019.11.15a-ver4.xlsx But to summarise I'm...

Hi Guys, I cant get this done and some help would be awesome. I've got 2 measures. 1st measure calculates count of ID's based on certain filters 2nd measure does the same I want to know if there are same ID's in both measures and count the similarities. I already tried to do something...

Hi, Does anyone have any experience of applying formats to pivot table measures conditionally based on their name? For example, if my measure has a (£) in its name, then apply a currency format, else apply a simple numeric format. I've done this kind of thing successfully with ordinary pivot...

Hi, I just opened my Excel workbook and noticed all my DAX measures that were sorted into columns are now in a random order. I've seen this before and moved them only to find them just thrown back into a random order. Any thought how to sort them again and avoid this. Thanks

This seems like it should be an easy solution, but my brain is having a freeze. I have a dataset that only allows me to create measures. I need a DAX that would let me create a revenue field if the customer name begins with I/C. Any suggestions?

I am trying to do something that should be simple, by my brain is having a dumb block. I have a table of sites showing their ranking for various performance measures. I just want to create a list showing which is their best and worst measures, but I'm getting confused where they may be the same...

Hello and thank you in advance if you can help, I am VERY new to using measures. I am using Excel 2019 on a PC. I have created some measures that will give me a distinct count of species in a query/dataset, as well as a distinct count of blocks. My data has fields/columns for All Regions...