Date Segmentations based on multiple measures
Hi guys, I need to segment my products into 4 groups all with distinct MIN & MAX ranges as shown below. I am wondering how best to create a dax measure to segment my products into these groups. Furthermore, I need to essentially have the ability to use that Product Type Group Name to be used within the Legend Field of a visuals (Scatter Chart) to visually showcase the sgementation over time. Currently, the scatter chart legend field only accepts colum references and not measures. Any help would be greatly appreciated!!
How to categorize or label date on a matrix/table ?
Hello! I want to "categorize" date on a matrix/table, just to clean it up and avoid repeating words in the rows. My matrix/table is this, each row is the value of a measure and I have 2 fact tables, INC_table & REQ_table This is my visual currenly, with the values shown per week. And this is how I would like to have as the visual I'm lost and not sure how can thisw be accomplished, If you have any ideas please send them my way Thanks in advance, Carlos
How do I create a measure to sum (total) up a distinct count?
Hi guys, As you can see in the picture down below I created a table with different colums: First column [VullingTotaalPerc] shows the percentage of version ID that are filled 100% and so on Second column [Count of Versies.Id] shows the count (distinct) of the total version ID. Third column [TotalVersiesIDCalculate] is a measure that I created that shows the count (distinct) of the total version ID but only for department X. Measure = TotalVersiesidCalculate = calculate(DISTINCTCOUNT(MKA[Versies.Id]),MKA[ProductieAfdeling]="COC2 en I&V") Fourth column [DistinccountVersies.id-Calculated] is a measure that I created that show the count (distinct) of versies.ID. DistinccountVersies.id-Calculated = DISTINCTCOUNT(MKA[Versies.Id]) Fifth column [COC2-Calculated] is a measure that I created - [TotalVersiesIDCalculate] divided by [DistinccountVersies.id-Calculated] to show what the percentage is of the total amount. The problem now is that when I use this formula: [TotalVersiesIDCalculate] / [DistinccountVersies.id-Calculated] the measure will divide 8 with 56 but what I want is that 8 will be divided by the total of 2533. Can anyone help me out here? Thnx!Create a new table from another and add new calculations from rows to columns
Hi, I need to create a new set of measures, but they depend of other values in a preexisting source of data. In SQL I managed this by adding CASE sentences to transform a row into a column and then I operated the columns, but in DAX I'm not sure about what is the best option, so I'm guessing that is through a new table with the SWITCH function involved. Let me explain my need: Thanks in advance
I want to take the average of the last 3 years of the total number on a monthly and yearly basis
Hi, I have a table like this. And I want to get the second table from this table. I try to use the rollup and sum functions with the filter but I can't find any solution for getting the right amount written in the table to show in a graphic. I wrote something like this but I should get also the next 3 years and the next three years till last year. Summary last 3 years = SUMMARIZE('Summary Incident Yearly' , ROLLUP(ROLLUPGROUP('Summary Incident Yearly'[Country],'Summary Incident Yearly'[MAAND])) , "3 years AVG", CALCULATE( SUM('Summary Incident Yearly'[amount])/3 ,FILTER('Summary Incident Yearly', 'Summary Incident Yearly'[JAAR]>=2015||'Summary Incident Yearly'[JAAR]<=2017)) , "Jaartaal", "15/16/17") JAAR MAAND Country amount 2015 1 Netherlands 1082 2015 1 Belgium 174 2015 1 Belgium 8 2015 1 Luxembourg 1 2015 1 Suriname 15 2015 2 Netherlands 1181 2015 2 Belgium 212 2015 2 Belgium 5 2015 2 Luxembourg 2 2015 2 Suriname 5 2016 1 Netherlands 1244 2016 1 Belgium 259 2016 1 Belgium 23 2016 1 Luxembourg 1 2016 1 Suriname 2 2016 2 Netherlands 1252 2016 2 Belgium 264 2016 2 Belgium 19 2016 2 Luxembourg 2 2016 2 Suriname 4 2017 1 Netherlands 1088 2017 1 Belgium 243 2017 1 Belgium 17 2017 1 Luxembourg 4 2017 2 Netherlands 1054 2017 2 Belgium 288 2017 2 Belgium 15 2017 2 Luxembourg 2 2017 2 Suriname 5 AVG JAAR Maand Country AVG 15/16/17 1 Netherlands 1138 15/16/17 1 Luxembourg 2 15/16/17 1 Belgique 120 15/16/17 2 Netherlands 1162 16/17/18 1 Netherlands etc 16/17/18 1 Luxembourg etc And at the end I will get a graphic like this : Thank you for your help
Save subtotal in measure and use as dynamic multiplier
Hello all, to illustrate my issue i would like to show the following screenshot As you see i have basically 3 categories of costs which is Picking (here i add up any cost except my storage costs) and the other 2 dimensions are costs for storage&unmoved storage cost. Long story short, i am desperately looking for a way to dynamically save the cost amounts for (Storage & Unmoved) in some kind of measure which is then used to be multiplied by the corresponding "Spread" in any line. It is important to understand that this is just one block of many within my pivot table, which means i have about 100 blocs of Picking | Storage & Unmoved sums, while for any of these blocs i need to find a way to dynamically store its corresponding amount for Storage in a variable which is then used within the lines above to multiply the spread with it. Any help or hint is highly appreciated! Thanks !
Improve visual table - problem with sum by dates
Hello everyone! I'm new in power bi (expert in Excel) and I did an dashboard based on varied data sources (Share Point List, Oracle and more). My dashboard presents the total manufactre work orders on the machines in my factory and also the invalid items that the QC department reject. When the user pick a date to slice, the data that need to show is the work order that active in the machine, according to the slicer date, and the total amount manufactre an the invalid item for this day only. My problem is when I make an visual table that need to shows the OEE of the machine in the amount of the invalid items, the visual table shows the total amount for the specific work order but nit according to the date slicer. I thought maybe to creat an marge table, but the data that shows for the invalid items is the total amount of all invalid items from day one. Here is an screensot of the visual table: Here is an screenshot of the invalid table according to the highlight exmple in the previous screenshot: Here is an screenshot of the marging table and the sum of the invalid items column formula:Average Last 6 months accumulated
Hello dear community, I come to you so that you can help me with this DAX calculation. I need a Calculated Column to show me: the average of the last 6 months accumulated for each collaborator (in case the collaborator appears> = 6 times in the year); or in the event that the employee in the current year period appears less than 6 months, showing the average based on the number of months that the employee has been in the company in the current period, for example: Year Filter: 2021 Current month: May2021 (5) Seniority of the collaborator to May2021: 3 months (that is, the collaborator appears 3 times until May, if in June it becomes active, the collaborator when we are in June then it will appear 4 times, and so on) So the average will be = (Mar + Apr + May) / 3 Also consider that I already have a calendar table in my Power BI. Here I have an example sample of what I want exactly (column "Average Last 6 months), you can download the file here: I also leave the extract here: I read them, I hope they can help me as soon as possible. and thank you very much in advance. Nestor ReyesCalculate the LY y YoY% of headcount
Hello friends, I am working on an HR Analytics dashboard, in which I want to calculate the following with DAX formulas: 1. Calculate Last Year 2. Calculate the YoY% As data to take into account: In the dashboard I will make filters at the year level I already have a headcount DAX : Headcount= SUM('01_Master Headcount'[Headcount]) and the graph that I want to create is exactly this: The data is assembled as follows (you can download the complete excel file with the data from this link: here) I hope you can help me. I'll be very greatful, Nestor Reyes
