Help with DAX when Multiple measures are used in Matrix
Hello All, This is very easy & silly DAX mistake I am doing, new to DAX so need your help to acheive the result. Attaching my sample pbix file here PowerBi Sample . If you see there I have a matrix visual where i have used multiple measures to calculate the count of cases on few conditions. Issue is when i click onany of the columns value belos printed table doesn't filter it properly. It is showing total row values. I want if i click on App team's implementation value, Table also show only those lines. Please help me with this asap. Thanks in Advance
identifying active users every month
Hi, I have a list of users every month, and i need to find the active users in every month. maybe by creating a new calculated column which states if the user is active or not - If the user names present in the next available month file then those user names are active or - if a new user appears for the very first time which are not available in any of the month files then they are active from that month onwards. Please note if user names not appearing continuously then they are inactive. please find the data like below: column names are: System user name,Count of System user name,Sum of cost,Monthly Source file Name System user name Count of System user name Sum of cost Monthly Source file Name User_A 3 € 112.50 24-Jan User_A 3 € 112.50 24-Mar User_A 3 € 112.50 24-Apr User_A 3 € 112.50 24-May User_A 3 € 112.50 24-Jun User_A 3 € 112.50 24-Sep User_B 7 € 149.50 24-Mar User_B 7 € 149.50 24-Apr User_B 7 € 149.50 24-May User_B 7 € 149.50 24-Jun User_B 8 € 238.50 24-Sep User_C 5 € 139.50 24-Jan User_C 7 € 151.50 24-Mar User_C 7 € 151.50 24-Apr User_C 7 € 151.50 24-May User_C 7 € 151.50 24-Jun User_C 7 € 151.50 24-Sep User_D 12 € 323.00 24-Jan User_D 13 € 329.00 24-Mar User_D 13 € 329.00 24-Apr User_D 13 € 329.00 24-May User_D 13 € 329.00 24-Jun User_D 14 € 332.00 24-Sep User_E 5 € 138.50 24-Jan User_E 7 € 209.50 24-Mar User_E 7 € 209.50 24-Apr User_E 9 € 222.50 24-May User_E 9 € 222.50 24-Jun User_E 9 € 305.00 24-Sep User_F 11 € 362.50 24-Jan User_F 13 € 374.50 24-Mar User_F 14 € 380.50 24-Apr User_F 14 € 380.50 24-May User_F 14 € 380.50 24-Jun User_F 14 € 463.50 24-Sep User_G 6 € 219.50 24-Apr User_G 7 € 226.00 24-May User_G 6 € 219.50 24-Jun User_G 7 € 246.50 24-Sep User_H 3 € 112.50 24-Mar User_H 3 € 112.50 24-Apr User_H 3 € 112.50 24-May User_H 3 € 112.50 24-Jun User_H 3 € 112.50 24-Sep How do i create this Active users list every month using the above data in power bi?? Thanks in advance for the helpFiltering by histogram bins in Power BI
Hi Everyone, In Power BI I have created a histogram that shows Number of People per Attendance Rate. To do so I have created additional table that defines the ranges for the histogram, which looks like this: HistogramBins: IDBinMaxMin 1 0-20% 0.2 0 2 20-40% 0.4 0.2 3 40-60% 0.6 0.4 4 60-80% 0.8 0.6 5 80-100% 1.01 0.8 Then I created the measure that would count how many people falls into each range by Attendance rate: Number of people per range = VAR minbin = SELECTEDVALUE('Histogrambins'[Min]) VAR maxbin = SELECTEDVALUE('Histogrambins'[Max]) VAR segment = FILTER( ADDCOLUMNS( SUMMARIZE('People', 'People'[ID]), "@Attendance", [% Attendance rate]), [@Attendance] < maxbin && [@Attendance] >= minbin) RETURN CALCULATE([Number of People], segment) It works nice for the Histogram itself, but I would like to add the option to click on Histogram bins and to have the rest of the report filtered for People[ID] that fall into each range. In the report I have slicer with Period (which is selected to show last 6 months) and an overview of Attendance rate per month which uses the measure % Attendance rate: % Attendance rate = DIVIDE ([Number of People]), [Number of Invitees]). It works when I am not filtering by histogram bins. I have tried to use CONCATENATEX list of People ID and then to filter the meausre by CONTAINSSTRING using People ID from the People table that is connected to People ID in the Attendance table, but when I click on specific bin, in the overview by month, it omits the months when Attendance rate falls below selected range per this month. I would like to separate somehow the inital range of Attendance rate from the second calculation of the Attendance rate so when I, for example, click on range 80-100% I would see the overview for people that fall into this range for selected period, even if for some months in the selected period, it falls below 80%. Would appreciate any help or hint.
Column Name Changes Every Month
Hello Everyone, This Data set has multiple columns where in Column 7 to Column 12 gets refreshed ever month. Example : For this month data starts from Jan 2023 to June 2023 For next month data starts from Feb 2023 to july 2023 Here Column 7 starts from jan 2023, Column 8 starts from Feb 2023, Column 9 start from mar 2023,,, Column with jun 2023 For next month Column 7 start with Feb 2023, Column 8 start with Mar 2023,,, Column 12 with July 2023 The requirement is 1) All the Column present in the data set should be placed in TABLE Visualization only. Problem : 1) when ever the Current month data is added to table Visualization ie., jan 2023 to Jun 2023 the visual looks fine. 2) as data gets refreshed next month (next month data start from. Feb 2023 to July 2023) Table visualization has only Feb, mar, Apr, may, jun. Where in July 2023 is not added to table visual as the Column name got changed hence my visual Breakdown. Need Help •Can we achieve this by index •Can we achieve this by dax with column7 is replaced by Apr 2023 •can we achieve this by power query dynamically • is there any way to achieve this.Unable to retrieve unique case number based on Message Date in Power Bi Desktop
Hello All, Can someone please help me to resolve the below issue. I have this table where in message date is the response received on the case number) and date/time closed is when the case was closed. I am trying to display only unique casenumber based on the latest message date along with timestamp. As you can see "00854913" case number is displayed twice as the message date timestamp is 6:55 PM & 1:47 PM.
Average values of a column within the week before with conditions in the month before
I have a table 'TableSales' with 3 columns 'Date' (in date format), 'Cashier', 'Sale Amount', and another table 'TableDate' with 2 columns 'SelectedDate' (in date format) and 'SelectedDate_text' (date but in text format so that I can have the last date as "The latest day" instead of the date). I use 'TableDate'[SelectedDate_Text] to create a slicer so that users can choose a desired date. I would like to create a measure to calculate the average Sale Amount of Cashiers per day during the latest 7 days until the selected date in the slicer. I can do that with the following query: average = CALCULATE( SUM('TableSales'[Sale Amount])/COUNT('TableSales'[Cashiers]) ,FILTER('TableSales', 'TableSales'[Date <= MAX('TableDate'[SelectedDate]) && 'TableSales'[Date >= MAX('TableDate'[SelectedDate])-6)) However, now I want to filter out all Cashiers with Sale Amount = 0 or blank during the latest 1 month until the selected date because those cashiers are assumed to be broken and shouldn't be taken into the calculation of average. How should I include that into my measure? Thank you.
Printing content of web link in power bi table [ column] in one go
I have use case , A table has column mnamed LINK. it hold https link to a pdf content. there will be more rows in table with link as column. I am trying find solution to have button [ one click] does below. 1. Iterates all the links in LINK column 2. hit the link and get the PDF content one by one 3. Send the pdf to printer. How can i achieve this ?
