DAX Running Total (ASC) by category
Hi, I have my data broken up into 100 groups and I want to know how much of an amount is left from the current row to the last row (100). The formula works well when I only have one state in the visual. If I add multiple states it breaks down. I have tried a couple of methods at this point, one uses IsOnOrAfter and the other just a filter between current row and row 100. I figure I am missing some kind of command with the [StoreState] Field but I am unsure how to proceed. Can someone help me calculate this running total by category? To Go Amount= CALCULATE( SUM('Table'[Amount]), FILTER( ALLSELECTED('Table'[StatePercentile]), ISONORAFTER('Table'[StatePercentile], MIN('Table'[StatePercentile]), asc) ) )
