The first condition, which is from the most specific to the least specific is that condition A, the base rows. Here is my changed version of the DAX expression with ISFILTERED in it; As you can see, I wrapped the measures value inside an IF statement like this: The above IF statement is only using the expression, and the what-if true, part of the IF. and use MIN formula ; John will show 2, Mark will be 2, Joe will e 0 and your Total will be 0 again. CALCULATE ( [Total Sales], DATESQTD (Dates [Date])) I would also suggest you make sure that your date table is Marked As Date Table. Don't I have to use the MIN or MAX function? COMMON POWER BI DAX MEASURES - Power BI Training - Data Bear So, if we have context for Period and we have context for Short month, then we just use the Spread Revenue measure because that was producing the correct results in those data rows. In many cases, where youre looking at multiple conditions, you could do this as a nested IF statement. And then finally, weve got the catch-all measure, which is if we dont have context in either of the two, then we just take the total sum of the virtual table. Can you describe this operation in detail ? Here you can find the available courses:\rhttps://curbal.com/courses-overview\r\r\r\rABOUT CURBAL:\rWebsite: http://www.curbal.com\rContact us: http://www.curbal.com/contact\r\r\r\rIf you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:\r\rhttps://curbal.com/product/sponsor-me\r\rMany thanks in advance!\r\r\r\r\r************\r\rWhat gear do I use to make my videos and run my business? Weve got a SWITCH TRUEstatement that is built from the general to the specific, and I want to show you why this doesnt work. If you ever want to provide something else as the result for the total row, you can then use the what-if false part of the if statement like below; in my case, I change it to All Customer text; And this is what the results looklike now: If you are just looking for removing the total for a specific column, and you dont want to spend time fixing your DAX codes, there is an easier way. duplicate the table in power query and leave only the columns witch contain the titles of those columns and the numbers that sum up to the total group by the column with the titles so now you have a new table witch contain those totals in your matrix and the titles you need then you apply thoses changes from power query Quick tip - Removing totals from a matrix in Power BI By Carmel Eve Software Engineer I 7th July 2020 (TL;DR - Create a measure which calculates the SELECTEDVALUE and use that rather than the table column to create the matrix) We have recently been doing a lot of work with Power BI. Create a matrix visual in Power BI - Power BI | Microsoft Learn Best Regards,Community Support Team _ Ailsa Tao. SUM is going to look at the 'Total Sales' column in the 'Sales' table and sum all the values together. Microsoft Power BI is a great tool for creating and publishing dynamic and interactive reports, but it has a few quirks that can be tricky to navigate. in this project, I'm using these measures with MIN and MAX to create my calendar: It's hard to say without seeing where you are using the Measure and the table structure but like I said the TOTAL row in Pivots won't sum up your values in the table directly if you use DAX on your value field. Youll find me here:\r Linkedin https://goo.gl/3VW6Ky\r Twitter @curbalen, @ruthpozuelo\r Facebook https://goo.gl/bME2sB\r\r#CURBAL #SUBSCRIBE Modify Totals Row in Matrix | Power BI Exchange Create a MATRIX (cross tabulation) Rows (Product), Columns (Year), Values (Revenue) Now, like in a pivot table show as a percent of the total Add Revenue to the Values area a second . Within the Tabular Editor 3, theres another way of visualizing this called the Pivot Grid. In a Table or Matrix it would be great having the ability to move the Sub-Total or Total column to the left side of the Table / Matrix. I want results like the image attached. for end-to-end power BI solutions, Power BI templates, or any kind of Power BI questions like Power query errors, Authoring and optimizing DAX codes for complex business logic. I learned some very cool tricks from what you built on top of my original solution. Power BI - How to add Drill Through to Reports - Xelplus - Leila Gharani B has context for the column, but not the row, while C has context for the row, but not the column. Now if we take that Spread Revenue and drop it into the field for the matrix, this is what happens (see below). Work with aggregates (sum, average, and so on) in Power BI With the Power BI Matrix visual element, you can make network visuals (now and then likewise alluded to as tables) in Power BI Desktop reports and cross-feature components inside the lattice with different visuals. Im going to go through a systematic process for fixing Power BI matrix totals that are broken and really break that down by components. This leaves a blank row though next to the Year row, and adds a new "Total" row description.