dax

Hello, For certain products, we have a variable pricing concept and through a power pivot table we're trying to determine - by product (row) - for every sales price (value) the mean, deviation from mean and standard deviation. We use measures in the pivot table to come to the standard deviation...

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

Hi, I'm new to DAX, but I'm sure the solution here should be relatively easy? Any elegant solution gratefully received. I need to be able to report where, between 2 Forecast versions, the Closure date for a Project has slipped (or accelerated). I've used 'Calculated Items' within an ordinary...

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

Can someone figure out what is wrong with my code? Purpose of the code: If the column Brand is filtered and SKU is not --> value sales of 2022 of the whole brand with all SKUs If the column SKU is filtered --> value sales of 2022 of a specific SKU If no filters --> value sales of 2022 of all...

Hi, I i have the following EVALUATE VAR NB = CALCULATETABLE ( Table2, FILTER ( ALL ( Table2 ), Table2[Column2] <> "B" ) ) RETURN NB is there a way to refer to 'column2' of the table NB, not the original so something like EVALUATE VAR NB = CALCULATETABLE ( Table2, FILTER ( ALL...

I have the following table in Excel: DATE VALUE 1/1/2024 100.00 2/1/2024 150.00 3/1/2024 200.00 4/1/2024 5/1/2024 6/1/2024 7/1/2024 8/1/2024 9/1/2024 10/1/2024 11/1/2024 12/1/2024 Lets say this table is called Table1. For the Months 4/1/2024 - 12/1/2024...

I have this DAX that is supposed to return appointments for the same day last week by each brand for each date. It is working absolutely fine and giving me the desired results as I intended. The only issue is that for some brands, where there are 0 appointments for the current date, it shows 0...

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

Hi All, I was wondering if anyone know how to count the number of Sick Occasions in Dax? i know how in Excel but dax is a completely different beast. Looking at the example i have posted. I want it to show 0 if they were not absent. Then increment once they become absent. But then they return...

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

I am creating a dashboard to display some calculated metrics. I have a detail with thousands of lines of submitted invoices. I have pulled out the Creation Dates, User, and the number of invoices submitted (by day and user), and I am trying to do some user level comparisons. I have been able to...

I have an Inventory Walk table that has month on columns and values on rows. Rows consist of Stock on Hand, Total Receipts, Total Demand, and Net Inventory. Stock On Hand is always the current month, then Total Receipts and Total Demand for each month. Net Inventory is a measure that is Stock...

Hey guys, I Need to create a PowerBI Matrix visualization, which should present number of issues that contain column AND row count value. I'll explain: In the following snapshot, you can see how my DB looks like (on left side): 'issue_id' and 'tags' (which present the issue tags) fields. each...

I hope this illustrates what I would like to do i fist have a virtual table filtered for just green products, and then a second for just red , I would like to filter the second table to show only customers or whatever that are contained in the first; EVALUATE VAR ttable = CALCULATETABLE (...

Hello Power BI experts. I have a dashboard tracking hours on various days, among other data points. I am using a SUMMARIZE table function, grouped by the columns you can see in the code below. The only problem I have is that the ClinicHours table does not have any data prior to 1/1/2023. I have...

Hi, I've created a dCalendar in Excel with all the dates for several years. I can pull the slicer and use it in my pivot tables. I can select the date, month, year... But for the QTR our year starts Feb 1. So I need QTR to date sales. That would be 4th QTR today all sales from Nov 1 to today...

Hi, this is more a a theory question than practical; in the measure ; Tbetween:=CALCULATE([TotalUnits], FILTER(ALL(Table1[Units]), Table1[Units] <= MAX(Table3[Max]) && Table1[Units] >=...

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