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?
Sum measure instead of calculate
Hi all, I want to sum the total meassurement instead of calculating it. My data looks similar to this Account number KAM Balance Unpaid Item Avg. price pr. item Theoretical value (unpaid*avg.price) 1 A 10.000 250 150 37.500 2 b 15.000 0 100 0 3 c 5.000 15 350 5.250 Total 30.000 265 200 53.000 I want it to sum the total in "theoretical value" instead of calculating it, so the value should be (37.500+0+5.250) 42.750 instead of (265*200) 53.000 Right now I have tried following Dax code Theoretical value test = if( HASONEFILTER(''[Account Number]),SUM(unpaid item) * AVERAGE(avg. price pr. item), ???????))) I dont know what to write instead of ????, to make it sum instead of calculate. Can you guys help me? 🙂 Thanks.12 Months Rolling Measure total incorrect in table
Hi everyone, I am currently facing an issue in DAX Power BI. I am trying to display a 12 Months Rolling Measure for customers. However, when displayed in a table with only 1 customer column, I have an issue with the totals displayed. I have been trying all kinds of solutions found online and suggestions from colleagues, but I can't seem to find the solution. I might be overthinking the problem and I'm sure an easy fix exists. Enough of me rambling, here is the DAX formula used for the 12 Months Rolling Sales measure : 12M Rolling Sales= Calculate( SUM([Sales Amount]; DATESBETWEEN('Dates'[Date]; NEXTDAY(SAMEPERIODLASTYEAR( LASTDATE('Dates'[Date]))); LASTDATE('Dates'[Date]))) I've tried using SUMX, Hasonefilter and Hasonevalue and even rebuilding the formula so that it's less complex, but everytime I have the same wrong total. Here's a very simplified example of the issue I'm facing : the total row is not correct Could anyone help me out ? Thank you very much, I'm really under lot of pressure to get this fixed. Thank you! Best regards Dino.
