I found a problem with this. In cases where the the amount showed as a Negative it did not roll up into the total/subtotal. Possibly because the SUMMARIZE list that Category was blank due to zero transactions for the year vs the previous year. Know of any way to get these negative amounts added back in?
This is a very informative video. Using DAX Studio to generate a summary table is very helpful in understanding what is going on in DAX. See the table in DAX Studio, then copy the code into into the table element in a measure in Modern Excel or Power Bi. For example, sumTable was constructed in DAX Studio. The measure was written in Excel. Thank you Chandeep! =VAR sumTable = ADDCOLUMNS( SUMMARIZE('RaceData', RaceData[Date], RaceData[Track Code]), "# of Races", CALCULATE(MAX(RaceData[Race #])) ) RETURN SUMX(sumTable, [# of Races])
Sum of Count = // [Products Count] = CALCULATE(DISTINCTCOUNT(Store[Product ID])) SUMX( KEEPFILTERS(VALUES('CALENDAR'[Qtr])), [Products Count] ) Hi Chandeep, I've tried in this method, which is giving same results.
Hi, this is great! One question, is there a way to do this to adjust dynamically based on dimensions? For ex. if I wanted to iterate only over year, over month and year, over year and product, etc? Is there a way of doing this without explicitly indicating in the measure the dimensions to use to iterate, and without creating separate measures for each use case? Thanks!
Thank you. Need your urgent help. Lets assume in one column (column 1) I am having Gross sales, Discount, COS 1, COS 2, Variable Expenses, Fixed Expenses, and Other Income. In second column I am having values of Total Transactions. If in a matrix I take Column 1 and Values in value column then the given subtotal is just sum of all of these. I need to have visible sub totals of Net sales, GP, NOP (before other income) and NP. Can you please advice
Why does DISTINCTCOUNT() return different numbers when you wrap it in CALCULATE() without any additional filters?? I have only ever seen CALCULATE() used in conjunction with other filters like FILTER() or ALL().
Please Make some Video of Tabular Editor Sample Case like Column Table This Month (have Column, [budget], Actual], and YTD (have Column, [budget], Actual]
Abolutely top teaching in DAX. I am very gratful Goodly for Your effort. I really hate dax, You are probably the one who knows how to present and teach what isr eally going on there :)with a step by step presentation in a very logical way. I really don't like ready to go solutions without explanation. Thanks once more. Top DAX channel! I also saw some solutions with SUMX(VALUES...) which looks similar in some way...is there any video which explains that solution?