measure

Hi everyone 😊 I still have a lot to learn about DAX and have become stuck trying to develop a measure that will filter down my source table to a single row by using values in two columns and return the (text) value from a different, specified column. I have two measures that filter a table and...

Hello all, I have the following DAX Measure: Total Deplaned Cargo = VAR TotalDeplaned = SUM(Cargo_Numbers[Ameriflight Deplaned]) + SUM('Cargo_Numbers'[American Deplaned]) + SUM('Cargo_Numbers'[Southwest Deplaned]) + SUM('Cargo_Numbers'[United Deplaned]) RETURN...

Hi all, I have a measure if statement to calculate the AAFR based on the different companies for YTD. When I set the filter to 'Maine Group' it calculates the correct value, when I select 'Smyth Steel' it calculates the correct value however if I don't filter the data I get a value approx. 10x...

Hello, I've been struggling quiet a lot with this issue and been looking high and low but I'm not able to find any answer. Hopefully some master can help me solve this issue! I have two table, lets call them Table1 and Table 2 in Power Pivot. They have relation to each other through Column...

Hello, I have a Power Pivot table (see below) that shows the emails reply rate (number treated/number received) for the employees of a company, If they replied to at least 80 % of the emails. the target is reached (YES). I have created a calculated column that show for each person, service and...

Hi, I'm having difficulty writing a measure that will for each month only pull through actuals values if there are any actuals values otherwise it should pull through the forecast values. So say a company is 4 months through its Fiscal Year it would show 4 months of actuals then the 8 months of...

Hi, I'm having issues trying to get totals to appear for one of my measures. Below is the table I'm creating and I've highlighted the issue I'm having. Below that is the meaures I've created. Any help would be appreciated. Lost Check 1 = ([FX Renewable Income (CY)]=0 && [FX Renewable Premium...

Hi all, I have this data, where all the rows with "Response" as "Distributed" have only blank cells next to it: RoleExperienceResponseIndexDistributed1Engineer≤ 10 YearsComplete2Engineer≤ 10 YearsComplete3Technician> 10 YearsComplete4Technician≤ 10 YearsComplete5Engineer≤ 10...

Hi All, I am trying to do the following, please let me know if this is possible: I have a "Value Field" called Count of Value_Proficiency which simply counts the occurrence of each Row Label I would like to create a new "Measure" having Max of Count of Value_Proficiency repeated for all Row...

Hi, I've been doing a bit of experimenting, so I have a simple measure ; SUM(Tsales [Units] ) Whichi I have then wrapped in a AVERAGEX and SUMX , its only a two column table Item and unit and I made sure I had duplicate values, which as it's tiny it is easy to see how the duplicates are...

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

Hello, I've been writing a few measures for power pivot, but am trying to get more familiar with the bi environment, and I don't know if I'm being really sturpid, but how do I look at the syntax for a measure already created in power bi, in pivot I just go to power pivot manage, and there they...

Hi, I need to calculate the voluntary attrition for employees who left the company within less than or equal to 6 months of their hire date. How would I accomplish this? I have below fields and tables: - Attrition Table that has below fields: - Employee ID - Hire Date - Term Date - Term...

I am trying to create a measure that will show how many members our group has gained or lost since our last month. The data source is a spreadsheet exported from our membership software once a month, with rows for member ID, member status, and a couple of other columns. I have transformed that...

Hello All, I have been trying to replicate excel Sumifs in Power BI without much luck. I have below excel data and a summarised table. The Table on the right in excel is essentially doing sumifs based on filter selection. For e.g. Sum of Volume for Customer =Cust 1, Product=Hat 1, Plan =A...

Hi I am looking for help with a DAX Measure. I have a list of milestones that might change each month. I am looking to do two things. - Return the latest status value of the milestone, - Count the number that match that status value, e.g.how many are now Green, Amber, etc. My data looks a...

Hi Guys, I have a corporate powerbi with a size limit, so I want to create a measure and not add another column to take up space. I have 3 tables MasterData, CBO (custoemer Backorders) & OnOrder (Supplier on order( all tables are linked to the Masterdata as the primary link and there are no...

I have the following dax measure in the value area of a pivot table to return a concatenated list of unique values from a table: =CONCATENATEX( Values( Table1[Column2] ), Table1[Column2],", " ) There are instances where 0 is returned as the value because no corresponding values...

Hi Forum, Quite straightforward I'm sure - but I'm new to measures in PowerPivot. I have three columns; Definitive Name, Yr.Mnth & Employee FTE. The table name is 'Summary Query'. I need a measure that will calculate Employee FTE based on the number of times that 'Definitive Name' appears in...

Hi! I´ve been trying to get a measure in my pivot table to get the % of reject orders of a partner / Total order order of partner, and that it can change if I use a slicer to change it by day, month, etc. This is an example of the data table which I use: And this is the pivot table which I...