DAX Measure - Group Total in each customer number row
Hi, I have a seemingly simple question, however, I just can't seem to get it right. My question is the following: I have customers divided into CSAC3 groups. So a customer belongs to a specific CSAC3 group. I have also created a measure that calculates the turnover TY. However, I now want to have a measure that adds up the turnover of the CSAC03 group and displays it behind the relevant customer number with the associated CSAC03 group. What I keep getting now is that it filters this turnover by customer number each time anyway. Ultimately, I want to calculate further using this turnover per CSAC03 group. But I can't get this to work. Below is an image of the table with columns Customer number, CSAC03 and Turnover MAP TY. This is on a customer number basis. Now I actually want another column next to it with Turnover MAP TY (CSAC03). So all the customer numbers with CSAC03 ‘4PLUS’ should include the total of this CSAC03 group. Furthermore, the code of the measure, perhaps this also has something to do with it. The tables are connected by means of customer keys/customer numbers. If anyone can help, please do, thank you!
Grouping dates into fortnights
Hi everyone, I'm looking for a solution that will help in grouping dates into fortnights, irregardless of month or year. I'll attach an image to help understand what I am meaning. It wouldn't matter if the column started at calendar start or a specific date. The date table I have is just an invoked funtion in M. Hopefully someone can help, I'm not sure what other information I could provide that would be helpful here.
SUM grand total per category
Hello everyone! I am new to Dax and am guessing the solution is right under my nose, but I've exhausted my limited knowledge and need some guidance. I have category (location) and subcategory (centers). A location can have more than one center. My dimension table Unidades uses the subcategory as primary key, since they aren't duplicate. There's also a fact table containing the amount of extra hours (R$) per location (category). When I put the information on a visual it repeats the corresponding overtime for every center according to its location. That's OK. My problem is that I need to add up the grand total of overtime hours, but my measure is adding the overtime for each center and not the location, wich means it adds duplicate values. How do I get the correct sum? Thank you in advance.Get the Quantity by the Earliest Date
Hello, I am trying to get the most recent quantity by production week, by Plant (Where it is produced) and by SKU (Item No) depending on the earliest date (version date). Can someone help me with this. I do not mind if it is done in DAX or Power Query. Below is my data view. I have tried groups but when I try to get the quantity it sums all the values up. I dont want that I want what ever was the quantity by the earliest plan version by item. ========================================================== Example of what I want: If I were to sum the quantity of production week of 9/25/2022 I would get like 900,000 (LBS) because it sums it all. I want to get the last value depending on the earliest or closest date of that production week for that Item and plant level. Let me know if I need to clarify anything. Below is an example of why the equal dates do not work:
Average a measure's results for a group
I've gotten rusty with DAX and this should be an easy formula, but I'm not asking it in the right way to get the right search. I have a function that calculates how many customers each team member has. I'd like to create a measure that calculates the average customer count for the entire team so the manager can see how close the individual is to the team average. Here's my data: To make it easier to understand, here it is summarized: The measure [Count of Cust ID] is DISTINCTCOUNTNOBLANK('Customers'[Cust ID]) I want to create a measure that will tell me the average customers for the entire team. So the average customer count for Jon Vander's team and Garven Dreis. So the In Garven Dreis's team, the average customer count should be (6+3+3)/3 = 4. I'm trying to create cards that the individual can look at. So if Briggs Darklighter gets to the page and selects his name in the slicer, he'll have a card that tells him his total customers (6) and another card that says average team customer count (4)Count items in COLUMN 1, filtered by COLUMN 2, grouped by COLUMN 3 ?
Good day, I’m brand new to Power BI and working on some reports. I’m wondering if someone can advise how to best work out (I assume via a measure) how many unique ID’s exist for a particular DisplayName, filtered on ClassName. In basic terms, using this example table, I want to know how many IDs exist for each specific Organisation. Or in other words, how do I count items in the FIRST COLUMN, filtered on THE SECOND COLUMN and grouped by the THIRD COLUMN? The results – based on this example – should be: Company 1 = 4 Company 2 = 2 Company 3 = 2 I am certain it is not too difficult, and I could do this calculation using SQL, but I’m just trying to wrap my head around Power BI and how calculations work there.
Apply difference to multiple IDs within a group in DAX
I have a table with daily Consumption totals and a fixed Capacity amount per ID. I want the Consumption value to be subtracted from the "first" ID's Capacity until it is 0, and then subtract the remaining amount from the next ID within the group. Desired output is the Amount Left column below: Date Group ID Capacity Consumption Amount Left 1/1/2019 A 1 10 8 2 1/1/2019 A 2 15 8 15 1/1/2019 A 3 15 8 15 1/2/2019 A 1 10 9 0 1/2/2019 A 2 15 9 4 1/2/2019 A 3 15 9 15 1/3/2019 A 1 10 10 0 1/3/2019 A 2 15 10 0 1/3/2019 A 3 15 10 1
