powerbi desktop

45 Topics

Header row missing quotes when using DAX Studio
Hello Community! I'm using DAX Studio 3.2.0 to export a Table from PowerBI (the table has 320k rows so the reason for using DAX Studio). It is working perfectly EXCEPT that the header row does not contain quotes... the rest of the entries are wrapped in quotes. Is there a setting I need to change? Below is my simple query to get the table out of PowerBI: // My Query EVALUATE( myTable ) Look forward to your help Ray
rayinOz
1 year ago Place DAX Commands and Tips
589Views
0likes
1Comment
Coverting a Visual Table into a Data Table in the same PowerBI
Hi there, Is there a way to convert or duplicate a Table Visual to turn it into a Data Table within the same PowerBI? I can export the Table Visual as a csv file and then do a separate analysis from there, but is there any way to do this within PowerBI where the table that is created is automatically updated when the visual table is updated? I tried creating a new table to try and use the SUMMARIZE function but the Table Visual is not selectable (because it is not a data table). Essentially I'm wanting to do further analysis based on one of the columns within the Table Visual without having to export it.
Solved
Keaganva
2 years ago Place DAX Commands and Tips
1.4KViews
0likes
4Comments
PowerBI- How to write a calculate column when two tables have many to one relationship?
Hi, I have two table App(one relationship) and App Role(Many relationship). The direction of filteration is from App to App Role. This is a directquery model so RELATED, RELATEDTABLE are not supported functions. I have two columns(Role, Type) in App role table. I am writing a IF condition in App table something like below but I get only 0's. PrimaryB_Individual(A calculated column I created in App Role table): PrimaryB_Individual = IF( 'App Role'[Role] = "PB" && 'App Role'[App Type]= "Individual", 1, BLANK()) Level 1 is in App Table. This formula only gives me 0. Level 1 = IF( IF(not ISEMPTY( 'App'), SELECTEDVALUE('App Role'[PrimaryB_Individual]) ) && 'App'[TBUS] <=24 && 'App'[NE] = "Existing", 1,0 ) Any comments on what am I missing?
Solved
Khushboo9966
2 years ago Place DAX Commands and Tips
2.7KViews
0likes
13Comments
Sum of Gross Values based on the max submission date for each App ID to show in a KPI Card
Hi Experts, I have daxed the below to be able to get the sum of the gross values where the latest submission date is picked for each application ID and summed with the others. This seems to pick for me only the gross value with the latest date based on all applications. The desire value needs to be 15,214.13 and right now it is showing me 1,982.33 I need to have the value in a visual card as a KPI . Not concerned with a slicer or anything. Unfortunately, I am not able to attach the powerBi file but I am attaching a snip of the Page visuals. $Gross Value = VAR _LatestSubmissionDate = ALLSELECTED('Table'[Submission Date]) VAR MaxSubmissionDate= CALCULATE(MAX('Table'[Submission Date]),VALUES('Table'[portalapplicationclaimid]),REMOVEFILTERS('Table'),_LatestSubmissionDate) VAR ActiveValue =CALCULATE(SUM( 'Table'[totaldisbursement_base]), FILTER('Table', 'Table'[statuscode] IN {"In Review", "In Review - Manager", "Submitted","Approved", "Opted Out"}), 'Table'[Submission Date]=MaxSubmissionDate) VAR RESULT = IF(ActiveValue=BLANK(),0,ActiveValue) RETURN RESULT How can I adjust this DAX to read properly? Not sure what I am missing or adding to the dax that it is ot reading properly.
Solved
kalkhudary
2 years ago Place DAX Commands and Tips
698Views
0likes
3Comments
Unable to save report to PowerBI Report Server after enabling HTTPS / TLS
Hi All, After configuring my PowerBI Report Server to use a TLS Certificate I am unable to save save reports from PowerBI Desktop to the PowerBI Server. I have tried nemerous fixes from threads on this forum, but the error persists. Please see ItemNotFoundException towards the end of the "PowerBI Report Server Error" section below. PowerBI Desktop Error: Saving to PowerBI Report Server An error occured while attempting to save the report to PowerBI Report Server. PowerBI Report Server Error: 2023-08-11 07:37:37.7626|INFO|1|File Logger created: D:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\RSPortal_2023_08_11_07_37_37.log - level Info, will roll at 32 Mb, process id 6376 2023-08-11 07:37:37.7776|INFO|1|Provider name 2023-08-11 07:37:37.7776|INFO|1|Container name Microsoft SQL Server Reporting Services Key Container 2010 2023-08-11 07:37:37.7776|INFO|1|Setting Symmetric Key 2023-08-11 07:37:37.7938|INFO|1|Setting up Hosted Process State 2023-08-11 07:37:38.0123|INFO|1|library|SQLDump flags: ReferencedMemory, AllThreads, SendToWatson 2023-08-11 07:37:38.0123|INFO|1|library|MiniDump flags: DataSegs, UnloadedModules, ProcessThreadData 2023-08-11 07:37:38.0123|INFO|1|library|Dump on: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogExceptionMicrosoft.ReportingServices.Modeling.InternalModelingExceptionMicrosoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException 2023-08-11 07:37:38.0123|INFO|1|library|Do not dump on: Microsoft.PowerBI.ReportServer.WebApi.Catalog.CatalogAccessExceptionSystem.Threading.ThreadAbortExceptionSystem.Web.UI.ViewStateExceptionSystem.OutOfMemoryExceptionSystem.Web.HttpExceptionSystem.IO.IOExceptionSystem.IO.FileLoadExceptionMicrosoft.SharePoint.SPExceptionMicrosoft.ReportingServices.WmiProvider.WMIProviderExceptionSystem.AppDomainUnloadedException 2023-08-11 07:37:38.0123|INFO|1|library|Minidump location: C:\Users\PBIRS_SVC\AppData\Local\Temp\ 2023-08-11 07:37:38.0123|INFO|1|Starting ReportServerWebApp 2023-08-11 07:37:38.0279|INFO|1|library|Catalog max connection pool size: 768 2023-08-11 07:37:38.0592|INFO|1|Working directory : D:\Program Files\Microsoft Power BI Report Server\PBIRS\Portal 2023-08-11 07:37:38.0592|INFO|1|Report Server url: https://powerbirs.domain.com/ReportServer 2023-08-11 07:37:38.0592|INFO|1|Report Server Web App virtual root: /Reports 2023-08-11 07:37:38.0592|INFO|1|Web app url: https://powerbirs.domain.com:443/Reports/ 2023-08-11 07:37:38.0592|INFO|1|Authentication scheme(s): IntegratedWindowsAuthentication 2023-08-11 07:37:38.1061|INFO|1|Catalog max connection pool size: 100 2023-08-11 07:37:39.1530|INFO|1|SecureConnectionLevel: 3. Redirecting HTTP connections to HTTPS. 2023-08-11 07:37:39.1842|INFO|1|crypto|Initializing crypto as user: DOMAIN\PBIRS_SVC 2023-08-11 07:37:39.1842|INFO|1|crypto|Exporting public key 2023-08-11 07:37:39.1998|INFO|1|crypto|Importing existing encryption key 2023-08-11 07:37:42.2780|INFO|4|<Header> <Product>Microsoft Power BI Report Server 1.17.8552.27722 (15.0.1112.48)</Product> <Locale>English (United States)</Locale> <TimeZone>UTC--7</TimeZone> <Path>D:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\RSPortal_2023_08_11_07_37_37.log</Path> <SystemName>SERVER-NAME</SystemName> <OSName>Microsoft Windows Server 2022 Standard Evaluation</OSName> <OSVersion>10.0.20348</OSVersion> <ProcessID>6376</ProcessID> <Virtualization>True</Virtualization> </Header> <ProcessorArchitecture>AMD64</ProcessorArchitecture> <ApplicationArchitecture>AMD64</ApplicationArchitecture> 2023-08-11 07:37:54.3873|INFO|7|Received request GET /api/v2.0/ServiceState| RequestID = s_94cef32e-9202-4680-8b64-a7b83ab3dac7 2023-08-11 07:37:54.6685|INFO|7|Sending response. Response code DOMAIN\User 200, Elapsed time 0:00:00.2801696| RequestID = s_94cef32e-9202-4680-8b64-a7b83ab3dac7 2023-08-11 07:37:54.8560|INFO|7|Received request GET /api/v2.0/CatalogItems(Path='/')| RequestID = s_4fd49dd9-9f8f-4890-a924-15e2c3b2bb27 2023-08-11 07:37:54.9498|INFO|7|Sending response. Response code DOMAIN\User 200, Elapsed time 0:00:00.0996048| RequestID = s_4fd49dd9-9f8f-4890-a924-15e2c3b2bb27 2023-08-11 07:37:54.9658|INFO|7|Received request GET /api/v2.0/catalogitems(e9dc2b00-9e76-4468-ab07-f057a3c589dc)/Model.Folder/catalogitems/| RequestID = s_65b472da-ee59-4477-8fb4-de5e00f67bd4 2023-08-11 07:37:55.0436|INFO|7|Sending response. Response code DOMAIN\User 200, Elapsed time 0:00:00.0817706| RequestID = s_65b472da-ee59-4477-8fb4-de5e00f67bd4 2023-08-11 07:37:56.6373|INFO|7|Received request GET /api/v2.0/CatalogItems(Path='/EDW')| RequestID = s_80135d36-17ab-40e2-b70f-8c5e372c6537 2023-08-11 07:37:56.6529|INFO|7|Sending response. Response code DOMAIN\User 200, Elapsed time 0:00:00.0127266| RequestID = s_80135d36-17ab-40e2-b70f-8c5e372c6537 2023-08-11 07:37:56.6529|INFO|17|Received request GET /api/v2.0/catalogitems(2ba032b9-e3f4-4fe6-871d-ceff0af2b983)/Model.Folder/catalogitems/| RequestID = s_e3ec502c-526f-40e6-bab7-733843633eab 2023-08-11 07:37:56.6529|INFO|17|Sending response. Response code DOMAIN\User 200, Elapsed time 0:00:00.0070938| RequestID = s_e3ec502c-526f-40e6-bab7-733843633eab 2023-08-11 07:38:02.5123|INFO|7|Received request GET /api/v2.0/CatalogItems(Path='/EDW/New_Report')| RequestID = s_b003b38d-5607-4d84-8661-6a422ee50bad 2023-08-11 07:38:02.5280|ERROR|7|library|Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: , Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item '/EDW/New_Report' cannot be found.;| RequestID = s_b003b38d-5607-4d84-8661-6a422ee50bad 2023-08-11 07:38:02.5435|INFO|7|Sending response. Response code DOMAIN\User 404, Elapsed time 0:00:00.0192931| RequestID = s_b003b38d-5607-4d84-8661-6a422ee50bad 2023-08-11 07:38:03.1374|INFO|17|Received request GET /api/v2.0/System/Properties| RequestID = s_a839f6f6-68a9-4fee-ae70-903a96e6da91 2023-08-11 07:38:03.1685|INFO|17|Sending response. Response code DOMAIN\User 200, Elapsed time 0:00:00.022886| RequestID = s_a839f6f6-68a9-4fee-ae70-903a96e6da91 2023-08-11 07:38:03.2779|INFO|17|Received request GET /api/v2.0/me| RequestID = s_55924c0b-902a-4c97-a43a-9e6a3f9818ec 2023-08-11 07:38:03.2935|INFO|17|Catalog max connection pool size: 100| RequestID = s_55924c0b-902a-4c97-a43a-9e6a3f9818ec 2023-08-11 07:38:03.2935|INFO|17|Creating default Global MeterCollector| RequestID = s_55924c0b-902a-4c97-a43a-9e6a3f9818ec 2023-08-11 07:38:03.3560|INFO|17|Sending response. Response code DOMAIN\User 200, Elapsed time 0:00:00.0758321| RequestID = s_55924c0b-902a-4c97-a43a-9e6a3f9818ec 2023-08-11 07:38:03.3560|INFO|17|Received request POST /api/v2.0/powerbireports(Path='/EDW/New_Report')/Model.Upload| RequestID = s_cd1ccc82-2e3e-4ee8-bd9b-b9eb4907a6c0 2023-08-11 07:38:03.3717|ERROR|17|library|Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: , Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item '/EDW/New_Report' cannot be found.;| RequestID = s_cd1ccc82-2e3e-4ee8-bd9b-b9eb4907a6c0 2023-08-11 07:38:03.4810|ERROR|6|The remote server returned an error: (503) Server Unavailable.| RequestID = s_cd1ccc82-2e3e-4ee8-bd9b-b9eb4907a6c0 2023-08-11 07:38:03.4810|INFO|11|Sending response. Response code DOMAIN\User 422, Elapsed time 0:00:00.1222532| RequestID = s_cd1ccc82-2e3e-4ee8-bd9b-b9eb4907a6c0 Thank you Stephan
Stephan_Louw
3 years ago Place Report Server
815Views
0likes
0Comments
How to change bar direction from horizontal to vertical in matrix visual in powerbi
How to change bar direction from horizontal to vertical in matrix visual in powerbi
hardikkeraliya
3 years ago Place Desktop
666Views
0likes
1Comment
Assign COUNTIF to row range (number of customers per number of transactions intervals)
Hi, community, I have a sales table, in which each row indicates a transaction. My end goal is to be able to show a consolidation of the number of customers in each fixed transaction range, exemplified in the "Number of transactions" column below. Number of transactions Number of customers 1 2 3 4 5 6 7 8 9 >=10 -- Let's look at the sample data: 1) This is a sales table, with 81 transactions and 8 different customers in a determined period Customer Name Transaction Date Transaction # A 20/01/2023 X1262 A 28/02/2023 X1718 B 03/02/2023 X1426 C 09/02/2023 X1496 D 09/02/2023 X1508 E 25/01/2023 X1311 E 27/01/2023 X1334 E 27/01/2023 X1336 E 02/02/2023 X1414 E 07/02/2023 X1478 F 15/02/2023 X1574 F 17/02/2023 X1613 F 02/03/2023 X1762 G 10/01/2023 X1181 G 23/01/2023 X1282 G 23/01/2023 X1283 G 31/01/2023 X1362 G 31/01/2023 X1363 G 13/02/2023 X1536 G 13/02/2023 X1537 G 22/02/2023 X1645 G 01/03/2023 X1745 G 01/03/2023 X1746 G 17/01/2023 X1227 H 07/02/2023 X1459 H 27/02/2023 X1543 2) If I was to do this in excel, I'd create an intermediate table with the number of transactions per customer A 2 B 1 C 1 D 1 E 5 F 3 G 11 H 2 3) And then I'd use another CountIF to aggregate the number of customers per number of transactions Number of transactions Number of customers 1 3 2 2 3 1 4 0 5 1 6 0 7 0 8 0 9 0 >=10 1 Seems very basic, but I didn't manage to do this 3rd step in PowerBI and it's been a few hours now 😞
Solved
Anonymous
3 years ago Place DAX Commands and Tips
674Views
0likes
2Comments
PowerBI - Timeseries of categorical changes
Hello all, I have a simplified PowerBI data model here: https://drive.google.com/file/d/13aXUR8mw2MdP3tw9K9LHxhqRCZqPaLwz/view?usp=share_link I want to make a timeseries visual that accounts for when a user's status category changes over time. This is what the model looks like: The current status table shows the status of users TODAY, and there is a separate table tracking the historical changes to their status. The visual so far looks like this: I need a measure of some kind that will evaluate the correct count of users' status over time. Something like: I have tried using LOOKUPVALUE, and different forms of CALCULATE but I haven't gotten very far. Any help is greatly appreciated! Thank you
CliffordAP
3 years ago Place DAX Commands and Tips
1KViews
0likes
2Comments
Need help in TOPN Dax measure
Hi All, I want to look at the top 10 campaigns for each month-Year by Unique Opens: Here are the steps i followed: 1. Create a column month-year in powerquery 2. Create a measure for total unique opens 3. Create a measure for TopN Here is the measure that i created. Doesnt work well. Top 10 Programs Per Month = VAR RankingContext = VALUES(CR[Program]) Return CALCULATE([Total Unique Opens],TOPN([Total Unique Opens],CR,RankingContext)) It gives more than 10 rows for the month-year with wrong sorting. Any help is appreciated
Solved
Anonymous
3 years ago Place DAX Commands and Tips
1.2KViews
0likes
4Comments
How to get the selected value from relative date slicer for showing the Dynamic Header.
I have Relative date slicer and I want to show what is selected in drop down for dynamic header. Example – Suppose slicer have following value – I want to show the dynamic header as "Last 1 Weeks". Please help me on resloving this. Thanks in Advance Sanjeev
SanjeevKumar
3 years ago Place DAX Commands and Tips
579Views
0likes
1Comment