sum based on some filter

8 Topics

Display total of sum per year
Hi, I would like to display the values as SUM of TOTAL PER YEAR as listed on the EXPECTED column below.. How do I do this correctly because on my graph that I have been developing it is displaying as the Total Allotted instead of the EXPECTED.. I have been experimenting with formulas but no luck 😞
Solved
GA1993
3 years ago Place DAX Commands and Tips
Views
0likes
Comments
Calculate Past Due Backlog Over Time
I have a data set that includes all line items sold, their due dates, actual ship dates, and value. I am able to calculate today's past due backlog (PDBL) by summing the value of all lines whose due date is before today but whose ship date is blank. What I want to do is to create a table that shows what the PDBL was on each day. I don't know how to do this. How can I create a table of dates and compare each line to the date in the table to say 'count me if my due date is before this day but my ship date is on or after this day'. I don't know how to create a table with dates that are not linked specifically to a date for each line item sold, because items can be counted in multiple days if they are late by multiple days. So if something was due 10/2/22 and shipped 10/4/22 I would want its value counted in both 10/3/22 and 10/4/22 of the table. What date do I use in my output table? Do I have to somehow create a new field? Would I create a measure to reference this new date field and how do I do that? Here is a quick very simplified example set of data and an example of what I want my output to look like: Example Data Order # Order Date Due Date Ship Date Value 1 09/30/22 10/1/22 10/3/22 $5 2 10/1/22 10/2/22 10/3/22 $7 3 10/2/22 10/3/22 10/4/22 $10 4 10/2/22 10/4/22 10/4/22 $5 5 10/3/22 10/4/22 10/5/22 $5 Output Visual: Date Backlog Value Backlog Count 10/02/22 $5 1 10/03/22 $12 2 10/04/22 $10 1 10/05/22 $5 1
Solved
aallman
3 years ago Place DAX Commands and Tips
Views
0likes
Comment
Lookup and sum with criteria
I am an absolute DAX beginner and am looking for a solution to the following problem: In the following table there are companies, departments, date (monthly period) and a value. Now I am looking for a way to create a DAX Querry which sums up all companies for a specific department (100 in the example). This in the current year and in the last year. A date table is already created. Questions: Which is the best variant for this case? Calculate(sum(Lookupvlaue... or Calculte(sum(filter.... Are there any examples for this case? Thanks for help
thebeginner1204
4 years ago Place DAX Commands and Tips
Views
0likes
Comments
Calculate and Sum with Wildcard
Hi there is there a possibility to set a sum from a filter with wildcard using DAX? I have a list of accounts. I want to sum the accounts >=10xx* and <=109x*. The accounts are formatted as numeric fields. Without a wildcard the filter works, but the accounts are dynamic, so I am looking for a solution to make it so. CALCULATE( SUM('TBL'[Sales]), FILTER(ALL(TBL[Accounts]),TBL[Accounts] >=10* && <=109*) ) Thanks for a Tipp Regards,
Solved
thebeginner1204
4 years ago Place DAX Commands and Tips
Views
0likes
Comments
DAX - Sum of the number of notes for each customer
I have a formula that calculates New Customers. Now I need to add the amount of "Outgoing Invoice" for each of them. Novos Clientes = var vPrimeira_Compra = CALCULATETABLE( ADDCOLUMNS( VALUES(SBOPRODMS[Nome do PN]), "Data_Primeira_Compra", Calculate(MIN(SBOPRODMS[Data NF])) ), All(dCalendario), SBOPRODMS[Documento] = "Nota fiscal de saída" ) var vResultado = FILTER( vPrimeira_Compra, [Data_Primeira_Compra] in VALUES(dCalendario[Date]) ) Return Countrows(vResultado) As an example below I have a customer with 11 invoices.
Solved
Diego_Vialle
4 years ago Place DAX Commands and Tips
Views
0likes
Comments
Sum with filter
Hi, I'd like help with a filtered calculation. I'm looking to sum the net sales but filtering out the other countries. Any idea as to the example dax?
Jameswh91
4 years ago Place DAX Commands and Tips
Views
0likes
Comments
Implement Aggregate Sum column based on values from other columns
Hello All I wish to implement a column D as shown in below screenshot using DAX measure such that Column D aggregation is sum of values in Column C. For Example, Value in Row number D3 is sum of values from Rows C3 to C8 such that it is aggregated on same supplier value from Column A from row A3 to A8 and the sum in row D3 must also correspond to MDF in row B3 with highest value in row C3. Is this possible to achieve in Power BI table visual using DAX ??
Solved
Anonymous
4 years ago Place DAX Commands and Tips
Views
0likes
Comments
Display Rollup Total at Row Level - Matrix Visual
Hi, I have a data model as shown below. I am trying to show a rollup of calls by employee. The desired result would look like: (#1) No Reporting Chain Level selected (#2) Select Senior from Reporting Chain level slicer See Jessica's calls and the sum of calls for all employees reporting into Jessica. I'm defining an employee reporting into Jessica as Jessica being present in "ReportingChainLevel2" column in Employees table. I have tried using a measure like below but it doesn't produce the desired result. CALCULATE ( SUM ('Employee Calls'[Num. Calls] ) , ALLEXCEPT(ReportingChainLevels,ReportingChainLevels[ReportingChainLevel]) ) I'm open to all suggestions. Thank you.
Standish
4 years ago Place DAX Commands and Tips
Views
0likes
Comments