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
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.
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 youNeed 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
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
Bar Graph Showing Percent Change per Category vs. Last Time Period
Hello all, Making a report but having trouble getting my desired visualization demonstrating percent change per category. Report pulls items (with a category column) produced in a week period along with value added (yield). Ideally, I'd like to create a bar chart that shows percent change of value added this week vs. last week for each category -- formatted like this: The weighted average for total items yield current week and last week are correct. To calculate percent change in total yield from this week over last week, I use this measure: Percent Change Yield Alt = DIVIDE( 'Production 22'[Current Week Weighted Average Yield], 'Production 22'[Prior Week Weighted Avg Yield]) - 1 Using that measure I've been trying to create another that store the weight average for each category rather than as a whole (I'm sure this has something to do with row context but I'm relatively new to this so I'm not positive). I've attempted a few different variations of this trying with DISTINCT, CALCULATE, or anything else I can find--I get a similar result though. At first I tried plugging in the measure "Percent Change Yield Alt" into the chart x-axis, which gives me this: From what I can tell, when there are multiple instances of items belonging to the same product category, that category's percent change will default to 5.24 (or the percent change in yield for total week production). Been trying some absolutely random stuff in order to try to get the correct numbers pertaining to each category. Here's one of my most recent efforts: Average2Change = AVERAGEX( DISTINCT(SELECTCOLUMNS('Production 22', " <y-axis (categories)> ", 'Production 22'[Percent Change Yield Alt], "Percent Change Yield Alt", 'Production 22'[Percent Change Yield Alt])), [Percent Change Yield Alt] ) This DAX results in the first bar graph from earlier in this post. Any help is appreciated.Calculate Total Session Time And Time Per Page
Alright so I am trying to tackle two things within the same table. (linked) I was browsing other threads, and most had the start and stop times of a session or a page in separate columns, my data is not set up that way. I tried adapting this measure, but it was not working. Total_Session_Time = var x1=MAXX(Filter(All(ui_PageActionView),[SessionID]=SELECTEDVALUE(ui_PageActionView[SessionID])),[EventTime]) var x2=MINX(Filter(All(ui_PageActionView),[SessionID]=SELECTEDVALUE(ui_PageActionView[SessionID])),[EventTime]) return x1-x2 My desired outputs are as follows: Total Session Time in Seconds/Min Total Time Per Page in Seconds/Min
