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.
Displaying a Row as Fixed, when it's value needs to be manipilated
*I have trouble converting the data type of Column Amount in Source ABC to Decial/Numbers for this tutorial(help needed), see data source:https://drive.google.com/file/d/1VZJv8sPPYPcLiRKyO1fkEqbcsX-dz10P/view?usp=sharing . PBIX:https://drive.google.com/file/d/1wfjbLI7nBLQU5-Qs5rGHOL2XP4uc0UR9/view?usp=sharing I am trying to include rows in a Dax calculation from a mapping table(Pivot) to a fact table(ABC). The DAX is going to look at specific rows and bring those forward. The big issue is some rows are not present in the Fact table. I also need those rows to be displayed but their values to be manipulated. An example is row "Interco capital returned", which is not in the Fact Table(ABC), it should display a fixed value of "678" TotalAmountForSelectedItems5 = CALCULATE( SUM('ABC'[Amount]), // Corrected Column Reference 'ABC'[Roll_Up_Function] IN { "Cash flow from ops - management", "Cash flow from trading", "Depreciation and amortisation", "IPEP expense", "Disposals & impairment of fixed assets", "Profit on disposal of pooling equipment", "Scrapped pooling equipment", "Impairment or valuation adjustment of pooling equipment", "Disposals or valuation adjustments of other fixed assets", "Other cash flow from trading adjustments", "Share-based payments expense", "Working capital mvts incl. provisions", "Working capital mvts excl. provisions", "Debtor movements", "Creditor movements", "Inventory movements", "Prepayment movements", "Provision movements", "Change in capex creditors", "Change in loss compensation balances", "Interco interest and guarantee fees", "Interco cash flows", "Interco royalties", "Statutory reallocations", "Internal restructuring", "Interco dividends Total", "Change in interco balances", "Change in interco recharge clearing", "FX on interco debt", "Interco capital returned" } ) amitchandak jpessoa8 lbendlinSPC Graph virtually blank when migrated into OnPremises (Remote Server) PBIX
Good Afternoon, I am building a new version of a Dashboard in OnPremises Remote Server (PBIX File). It had originally been developed in the previous Desktop version. I am using the following SPC (Dev) Chart: Id: PBISPC_DEV Version: 1.4.4.20 In the previous Desktop version, a graph appears as this: But when I copy the exact graph into the new PBIX File (OnPremises Remote Server), it comes up virtually as a blank (in spite of all Tables and Measures being migrated over): Kindly Advise.Migrating Pages from one PBIX file (Desktop) to another (Onpremises Remote Server)
Good Morning, I am building a new version of a dashboard (into Onpremises Remote Server Version: 2.150.1926.0 64-bit (January 2026) from a version previously created in Desktop 2.145.1105.0 64-bit (July 2025)). There are over 30 tables and over 15 pages in the existing dashboard. I am moving across the Tables (to the new PBIX file) and creating the relationships between them manually. I considered it better to make the effort to manually join the tables in Model View - rather than autodetect - so that I know exactly what Table is linked with which Table (and upon what fields). Or would autodetect have been preferable ? Now the main issue is copying the 15-ish pages (with the plethora of visuals contained within these !) to the new PBIX file, especially that several of them contain Overlays (with buttons allowing different views of the data to be presented). So such pages may have many Visuals contained which are hidden - dependant on which view button has been invoked. For example: Kindly advise if there is an efficient way to move across the pages. RegardsCopying Field Parameters to Onpremises (Remote Server) PBIX
Hi, I am trying to find a correct and efficient way to copy the Field Parameters from an existing PIBX (in Desktop 2.145 64-bit, July 2025) to a new empty PBIX file (in Onpremises-Remote Server). In the Onpremises-Remote Server version, one cannot use the Tabular Editor tool. Also, I am unable to see the Field Parameters in Transform Data, of the already-completed Desktop version (from where I could copy them over to the new PBIX of Onpremises (Remote Server) version). It is only showing the Tables themselves: Kindly advise how I can copy over the Field Parameters. Regards
Previous Year Measure for Line Chart
Hello. I am trying to create a YOY cumulative active customer by month line chart. The line should show the number of customers who made at least one purchase. One for Selected Year and another for Selected Year - 1. And, the total is rolling, so the line should be going up over time. Because there is a year filter in play, I am having difficulties writing a measure that provides a PY Active Customer line for the line chart. If I have 2026 selected, previous years' active customers is reduced. So, I have to removefilter the Calendar. However, this causes the PY active customer line ignore the month on the X axis resulting in a flat total line. Please help me write a measure that accurately calculates PY active customers and still works in a line chart. Should look something like this: Sample file here. Thanks.
