Power BI Community Profile Retrieval
Hi Team, I have been using Power BI Community for the past 8 years. Recently my work email got expired, from that point my Power BI profile is inaccessible. For the purpose of asking this question, I have created a new profile now. Is there anyone who can support / who can help with the place I should reach for retrieving my Power BI profile Thanks, ThejeswatDP-600 Voucher Application Correction
Hello Fabric Team, I accidentally submitted my DP-600 voucher request before completing the practice assessment. I have now completed it and scored 94 percent. I also emailed the team with all the details but have not received a reply. Could you please help review my request with the updated score? Thank you.
Html error 'spam' style
For a few weeks now whenever i try and publish anything i get that error message, even if i just have nothing but text and have attached an example file. what can i do , this only started after last update, before that all worked fine. is it just a case of go back to forum? i would show a screen shot but that would probably make this invalid as well. Richard.
Problem with Inspiration, Power BI galleries?
I can't see any Power BI reports in Power BI galleries For example, when I click on Fire! Leicestershire Fire and Rescue Service incident report | Microsoft Fabric Community I see the following Same for all in Contests Gallery | Microsoft Fabric Community Themes Gallery | Microsoft Fabric Community
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 lbendlin
