Help! explain this measure and why it isn't working consistently!!
I have a report that someone else made and they are not seeing some data show in the visuals that they would expect to see. After investigating I found out that the measures are behaving strangely. Basically there are 3 measures. One determines if there are any items on a SalesOrder that have a synthesisDepartment of "LEU Main - Tubes" : HasLEUMainTubes = VAR CurrentSalesOrder = MAX('vwOperationsBacklog'[SalesOrder]) RETURN CALCULATE ( COUNTROWS ( 'vwOperationsBacklog' ), 'vwOperationsBacklog'[SalesOrder] = CurrentSalesOrder, 'vwOperationsBacklog'[SynthesisDepartment] = "LEU Main - Tubes" ) One determines if there are any items on a SalesOrder that have a synthesisDepartment of "LEU Platinum" : HasLEUPlatinum = VAR CurrentSalesOrder = MAX('vwOperationsBacklog'[SalesOrder]) RETURN CALCULATE ( COUNTROWS ( 'vwOperationsBacklog' ), 'vwOperationsBacklog'[SalesOrder] = CurrentSalesOrder, 'vwOperationsBacklog'[SynthesisDepartment] = "LEU Platinum" ) And the third measure determines if the SalesOrder has items from both departments: HasBothLEUMainTubesAndPlatinum =IF ( [HasLEUMainTubes] > 0 && [HasLEUPlatinum] > 0, 1, 0) The visual is a table that displays a list of SalesOrders that have both Main and Platinum items. However, the users only want to see $ values and specific products that are from Main and have applied a visual level filter of Synthesis Department = "LEU Main - Tubes". Here is the issue: In most cases, this works out fine. Example order 9558544 which has 8 items in each of the two departments shows up in my main visual with only $ associated to the Main department. BUT example order 21583399 does NOT show up in the table even though it has 2 Platinum items and 3 Main items. I created a quick look at these 2 orders and the results of the 3 measures below (separated by Synth Dept) As soon as I apply a visual level filter to that same table (setting Dept = Leu Main - Tubes), this is the result: WHY DOES ONE ORDER WORK DIFFERENTLY FROM THE OTHER????? I also know I could probably come up with a better way of doing this (I did not develop these measures, a user did) but I ultimately want to know why it functions like this.
Bug: Base64 Text Measures break down when having Calculation Groups
Hi all. I have a few concatenate measures to bypass the 32000-character limit in Power BI - They all work fine until I add a calculation group and calculation item - they all break down then. You don't even have to use it - the mere existence of a calculation item is enough to break them. I cannot find much info on the web about this very niche issue. Hopefully, someone has an answer/explanation. Cheers, Quang
Create measure to calculate the difference in values between latest date and previous date
Hi everyone, I need some help. I've already tried different things, including asking LLM, but without any success, so I'm here to ask smarter people for help. I'm trying to create a measure that will give me the difference in a value for a specific entity between the latest date and the previous date. I have 2 tables. The first one contains the date and the entity name and the second one contains the value I want to measure. Both tables are related by a key column and the dates are not daily dates, but ad hoc dates. Something like this: The results I expect to see from the measure should look something like this: And I should be able to put the measure on a card and filter it by the entity name to display the related result. I have tried calculating the latest and previous date and then calculating the corresponding latest and previous value but when I ask to return the difference between latest and previous I never get those expected numbers... My guess is that I'm not using the right formulas to calculates the latest and previous values... Does anybody have an idea? Before anyone asks, I cannot change how the source tables look like as they are automatically generated by a third party software. Thanks in advance.
Actual vs Budget vs PY in a Matrix with Scenarios in the Column
Hello, I am trying to create a measure that provides one scenario (actuals) vs. a second scenario (budget). I can make actual sales vs. budget sales and get a figure, but I want the formula to be generic enough to use with any of my line items and get an answer. i.e. a 4th column in the screenshot below for each line item a difference will appear based on each scenario (actual - budget and actual - PY). 🙂 Thanks.
Actual vs Forecast vs Budget Variance
Hi Team, I am currently working in Power BI to see the variance in Matrix table for Actuals vs Budget and Actuals vs Forecast. as per the below screenshot for sample data. I am attaching herewith the sample data for the resolution. I have all the view but only left with the variances. View required in Power BI. Looking for a DAX query so that I will be able to get the Variance with this data set. If there would be any other suggestion so please let me know. Data Set Thanks, RakeshCounting Active employees per month
I would like to count the active headcount for each month but I seem to be running into a road block with the following formula. The fact table (sample below) does not have an active relationship with the calendar table. It is not counting the rows for each month, per Platform, and instead is counting the total # of rows based on the first set of filter criteria in the CALCULATE function but I do not understand why. Active Count = VAR LastDateInPeriod = MAX('Calendar Table'[Date]) VAR FirstDateInPeriod = MIN('Calendar Table'[Date]) RETURN CALCULATE( COUNTROWS('Worker Table'), 'Worker Table'[Worker] = "CTE", 'Worker Table'[Record Type] IN { "Keep Active", "Release - Starting Count", "Conv RBG - CTE Starting Count" }, FILTER( 'Worker Table', 'Worker Table'[Worker Start Date] <= LastDateInPeriod && OR('Worker Table'[Worker End Date] >= FirstDateInPeriod,ISBLANK('Worker Table'[Worker End Date])) ) ) Sample table data (not representative of the full table, but so you know the structure): Platform ID Worker Start Date Worker End Date Worker Record Type Platform1 ID1 12/01/2025 04/01/2026 CTE Release - Starting Count Platform1 ID2 11/12/2025 04/10/2026 CTE Release - Starting Count Platform1 ID3 02/24/2026 04/17/2026 CTE Release - Starting Count Platform1 ID4 10/22/2025 04/30/2026 CTE Release - Starting Count Platform1 ID5 10/15/2025 04/30/2026 CTE Release - Starting Count Platform1 ID6 12/11/2025 04/30/2026 CTE Release - Starting Count Platform1 ID7 02/07/2024 05/31/2026 CTE Release - Starting Count Platform1 ID67 08/04/2025 08/01/2026 CTE Conv RBG - CTE Starting Count Platform1 ID144 09/01/2025 10/01/2026 CTE Conv RBG - CTE Starting Count Platform1 ID272 03/27/2023 CTE Keep Active Platform1 ID273 05/05/2022 CTE Keep Active Platform1 ID274 10/23/2024 CTE Keep Active Platform1 ID275 03/27/2023 CTE Keep Active Platform1 ID276 04/15/2025 CTE Keep Active Platform1 ID277 05/29/2025 CTE Keep Active Platform1 ID278 10/29/2024 CTE Keep Active Platform2 ID279 03/08/2023 CTE Keep Active Platform2 ID280 10/08/2025 04/30/2026 CTE Release - Starting Count Platform2 ID281 01/28/2026 CTE Keep Active Platform2 ID282 10/20/2025 12/01/2026 CTE Conv RBG - CTE Starting Count Platform2 ID283 11/10/2025 06/30/2026 CTE Release - Starting Count Platform2 ID284 11/03/2025 CTE Keep Active Platform2 ID285 07/21/2025 06/30/2026 CTE Release - Starting Count Platform2 ID286 12/01/2025 12/01/2026 CTE Conv RBG - CTE Starting Count Platform2 ID287 11/10/2025 CTE Keep Active When I select a specific Platform it gives me a smaller number (total rows) but isn't filtering down to the Platform specifically for each month:
