measure

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(...

Hello everyone, I have a QTD measure that is almost working, It calculates the current QTD value exactly as I would see it in our ERP, but I would like it to respond to the month selection, based on a <= calculation. My current measure is, =CALCULATE(SUM('Income...

Hi, I created a measure to countrows using search to return part of a text which is working fine but I wan't to add to this measure to also count values from another column based on criteria that it does not equal blank. Here is the dax formula...

I need help creating a DAX Measure. I have tried 8 different DAX Measure Formulas, all will spectacular failure. Here is my situation: 1. The attached file has one workbook with five tabs (sixth is the “Pivot” tab I’m trying to build). 2. The Data Model has all Tables added with the...

Hey guys, Does someone know how to dynamically display current quarter with possibility to filter for previous quarter as well in a table without month - quarter details ? Table is like product for rows and revenue, units,.. in columns. It does work with Calculate function like this one below...

Hi Everyone, I've got an issue where I can't figure out how to exclude rows without data in certain columns/measures. I've attached a picture to show what I'm talking about, specific issue is outlined in red. The two rows (week numbers) without data in the "Downstock Hours" measure are...

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. I just started playing with DAX formulas and Power Pivot. I would appreciate any hints on how to do the following: There is a list of stores (green table) with a sales value for a date. I added this table to the data model and created a Power Pivot. Using the measure: Months by...

Hi All, Can anybody help me with a formula to measure employee performance. Our department job is to prepare reports , so some reports have frequency , it means the submission of reports are daily/weekly in nature. While others are huge data based which is time consuming. Few are critical in...

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...

Hi, I have written a measure in DAX to calculate the turnover of the past 12 months (Rolling 12 months) per customer: CALCULATE([Turnover]; FILTER(ALL(T_Calendar); T_Calendar[MonthNumber]=MONTH(TODAY())-1&&T_Calendar[Year]=YEAR(TODAY())...

CompanyID Total_Sales 1 5 2 5 3 5 4 5 5 5 I have a measure Total_Sales. The total needs to be allocated to the parent company in another measure. The parent company has an ID of 1 in the example above...

I have a worksheet as ff: column A Column B Column C materials unit of measure quantity sorted on column A then SUBTOTALed on column C but after that -- only Column A & Column C were shown the column B is blank! is there a way to...

I've got a date measure that works with some operators but not others. Perhaps someone can tell me what I'm doing wrong in formatting? I get an error that the date measure is a text measure and DAX cannot compare text and dates, but only for certain operations. I've got an inflation formula...

Hi, I have a table in an excel file which has auto filters on and I have pivot tables derived from it. The table is included in the data model. I have slicers on the pivot tables, which are on different worksheets but, I want to filter all of the pivots together by selecting the visible cells...

Hi, I have this example in my onedrive. Link: https://1drv.ms/f/s!As8YC7wZr8RKist1_Ql70SsOKar7yA I create the measure MEDIAN. I would like to count how many itens in the Subcategory column Greater Than the MEDIAN. Could this calculation be done as a measure, not column?

Hi, I have just started with power pivot for the analysis of the company data. I have written a measure to detect new customers. the measure is: =CALCULATE( COUNTROWS(Klant_Groepen), FILTER(Klant_Groepen, CALCULATE(COUNTROWS(Dossier))>0&&...

Hello, I am to figure out if it is possible to use a calculated column in a measure. The Calculated Column counts number of accounts per user: #ofAccounts =IF(ISBLANK(CALCULATE(COUNTA(Accounts[Contract Id]),FILTER(ALL(Accounts),Accounts[Contract Id]=Contracts[Contract...

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...

My piovt has LOCATION and PRODUCT for the rows and REVENUE for Value. My goal is to create a new MDX Calculated Measure show each PRODUCT its % of it LOCATION REVENUE Total. Therefore, I created separate "Product Rev" & "Total Product Rev" measures....the a "% of Total" measure where [Product...