measures

I am attempting to become more efficient with a process I do monthly by utilizing Power Pivot (which is new to me) verse excel and multiple formulas. All of my data is in one table and I'm attempting to replicate the formulas that have been created for use in excel for use in Power Pivot...

I am using Power Query and Power Pivot. I have a list of support tickets with dates opened and dates closed. I want a pivot table to count the number of tickets opened for a month and number of tickets closed for the month. When I create a slicer for each, it has to be two separate slicers. An...

Hi I am starting to play with Power BI and am trying to do some conditional formatting on a matrix. The measure that I have written works but has hard-coded values. The conditional formatting itself is being done on the measure using the rules of if value is 0 then colour white, if 1 then...

I have some data in the data model, and when I go into the measures to create a new one, the tables/columns etc are not pulling up as choices to use hen start typing them. I thought well maybe my query was broken so I physically copied the spreadsheet into the workbook and tried adding to the...

Hi, is it possible to create a pivot table based on the results of another pivot table. I have an inventory table that has items and a measure that calculates slow movers and fast movers based on how many units are sold each week. I then pull the information from the powerpivot table into a...

I'm looking for a best practice as to how to handle changing measures when your source data changes. We're in a (continual) fact-finding mode with our data. The extracts from our various ERP systems are complex, such that the names and logic of columns can change as we slice 'n' dice and come...

In my current role I am using Excel 2010 with PowerPivot One of the reports I produce is a tabular pivot table with one row for every row in the source table. Instead of dragging multiple columns into the row labels area, thus slowing an already slow environment, I am using measures to show the...

Per the title, I can see the added table in the Measure Edit window, and I can see it in the Power Pivot window, I can create a measure that accesses it's columns, but I can't see the table or the measure in the PivotTable Fields window, even if I select ALL. Has anyone else seen this type of...

Hi, currently I work in excel, power pivot. Here I have added a number of measures and calculated columns. I would like to continue working in Power BI. If I load the current file via "get data", I only have the original data. Is there a way to add the already-written measuers and...

Hi All: I am relatively new to DAX and having issues arriving at a total for a measure. The measure is: Result:=DIVIDE([Value], [Factor]) [Value] and [Factor] are two measures calculated in the model and work fine and trying to achieve Result by dividing one by the other. Result total shows...

Is there a straightforward way to do this? Clearly I could union two tables together, but that seems a massive pain. I just want to drag two measures into the value area of a line chart!

I used disconnected slicers to choose from various measures for display. The individual measures can be percentages, currency, or regular numbers, so the "master" measure in the SWITCH function has a generic "General" format. It would be handy for the users to see the format matching the...

I am new to this DAX language and I am sure the solution isa very simple one, but I would appreciate some help.<o:p></o:p> <o:p> </o:p> I have created two measures. <o:p></o:p> MAX MONTH=MONTH(MAX('MONTHLYSALES 002'[Date])) 2016 ADJ NET SALES-YTD= CALCULATE(SUM([ADJUSTED NET SALES])...

Hello, I've been googling a lot before to post this question but I have not been able to find any answer. I have a table named "TABLE" (say) and I defined a measure in it named "MEASURE". Now, in another worksheet I can use a formula like this: =SUMIFS(TABLE[Amount];TABLE[ID];10), where of...

I have a fact file containing a column of measures and corresponding values, for example, <tbody> Measure Value Volume 100 Revenue 70 Cost 20 </tbody> This is repeated for thousands of transactions across many months - so my table is a few hundred thousand rows. I want to write...

Is there a better way to transfer all the measures from an excel sheet to power bi than copy pasting one at a time.

Hi, I have a pivot table whose source data is a powerpivot model. When I try and reference a cell from the pivot table in another formula I get a #REF! error. As an example the pivot table is as follows: and the formula that has the #REF! result is: =+GETPIVOTDATA("[Measures].[Sum of...

Hello everybody, I have a trouble with getting ModelMeasureNames collection of Power Pivot model by using Excel/VBA. I can't find any function that would allow me to do this. I can get the Power Pivot model of the workbook by ActiveWorkbook.model. But this model object does not have any...

I'm a PowerPivot newbie and once again I'm stuck in the very basics of using the PowerBI. Here's my table setup: Table fSales has fields like StoreID, ProductID, Payment Method and Sales Amount. It's joined to TbStores with the StoreID, tbProducts with the ProductID and tbPAymentMethods...

Hello All, I am struggling to develop a PowerPivot measure that can project global MTD and/or YTD figures based on sales in different areas of the world. I have no issues with the measure assuming the globe runs on the same calendar, but I am running into challenges having the calculation be...