How to prevent a measure from being duplicated in each column when using a matrix in Power BI
Hi, hope you have a good day. Please your help with this, I have not been able to find the way to create this visual in Power BI and it seems to me quite simple. I have used the matrix where I can show the measure A for each selected month, so far so good. Now, I need to add a single column with a calculation that takes into account different months (Measure B), "similar to a total but with a specific operation, not a simple sum, average etc" when i add the value the column is duplicated by every month and the value is affected by this filter, I just need to show it at the end of the table once. This is the example in excel of what i want to do, I have looked in the customization options of the table but I can't find the way to do it. I would appreciate it if someone could help me
static grand total in matrix when filtered
Hi, I have a matrix with different countries as rows and Value (USD) as values. If I filter on a country, I want to keep the grand total unchanged. So in this case, if I filter on Zambia, I want it to show 103.55 for Zambia and 287,524.39 for Total. Is it possible?removing subtotal for specific field in matrix
i created a matrix that shows for each laundry : total orders, revenue, arrow indicator trend per month in the rows i have : -Laundry Name -MonthYear and in the values i have : -successful orders -orders arrow indicator -total bill amount -bill arrow indicator im getting subtotals for all the values i have but i want the subtotal to be hidden/removed for the arrow indicator only. i used the function (hasonevalue) which has worked but one issue is that if a laundry has a value for one month , the subtotal for arrow indicator will be shown. example : how can i remove the subtotal for the arrow indicator value only , even if it has one value ?
