measure is not showing total value in table visual
hi everyone i have created a measure that calculates sales agents commission based on his achievment % for each sales category. when i added the measure to a table visual, it's showing the the total value of the table visual as 0 instead of summing the commission values for each category. the total for measure 'new commission calculation' shoulde be 660 instead of 0 and the total for measure 'new agent incentive' should be 225 instead of 0
Running Total calculation based on criteria
Hi All, I would like to ask your help to solve to following running total calculation problem as it is clearly above of my DAX knowledge. Please, see this PBI file link for more details: RunningTotalDemo I want to use running total from the actual month(presently 202107 and provided by m_ActualMonth measure) which base value is calculated on the following way: ActualStock.Quantity + IODiff of 0BeforeActual + IODiff of actual month(202107). In other cases only the IODiff is counted. This calcualtion is provided by m_StockIODiffForRunningTotal measure: m_StockIODiffForRunningTotal = VAR ActualMonthValue = SUM ( Material[ActualStock.Quantity] ) + CALCULATE ( SUM ( StockInputOutput[IODiff] ), StockInputOutput[YearMonthAndBefore] = "0BeforeActual" ) + SUM ( StockInputOutput[IODiff] ) VAR Result = IF ( MIN ( StockInputOutput[YearMonthAndBefore] ) = [m_ActualMonth], ActualMonthValue, SUM ( StockInputOutput[IODiff] ) ) return Result The first matrix shows the IODiff and the second shows the calculated running total in the value area: The calculation of running total is ok, but there are some flaws, please see the color signs on the picture. green: in case if the actual month(202107) as value then the m_StockIODiffForRunningTotal provides the correct value red: if no value in the actual month, the m_StockIODiffForRunningTotal doesn't work orange: the 0BeforeActual column is filtered because of the running total formula but it should be visible in the matrix. My questions are: - how can be calculated the "ActualStock.Quantity" + IODiff of 0BeforeActual if the actual month(202107) has no any value? - how it is possible to calculate running total from the calculated actual month(202107) and show the 0BeforeActual column in the visual at once? Perhaps it is not possible if I use FILTER function in the running total measure: m_RunningTotal = calculate( [m_StockIODiffForRunningTotal], FILTER( ALL(StockInputOutput[YearMonthAndBefore]), StockInputOutput[YearMonthAndBefore] >= [m_ActualMonth] && StockInputOutput[YearMonthAndBefore] <= max(StockInputOutput[YearMonthAndBefore]))) Thank you very much in advance!Easy in Excel but not in Dax Measure (running total)
Hi all, I need to replicate a calculation I have in Excel using a DAX measure. It's to get a running total. It's B3 - C3 + D2 (where D2 is the running total copied down the column). Can column D be calculated using a dax measure in PowerBI? I can calculate the running total of column B using: running total measure of amount1 := VAR IndexID = SELECTEDVALUE( 'ID_Table'[ID], 0 ) RETURN SUMX ( FILTER ( SUMMARIZE ( ALLSELECTED ( 'ID_Table' ), 'ID_Table'[ID], "RunningTotal", [Amount1] ), 'ID_Table'[ID] <= IndexID), [RunningTotal] )Running Total (based on project size)
Hello, I need help in creating a Running Total measure, but what is important - it should be based on projects, not dates. Usually, Running Total is created by date, we start in January and increase e.g. the sum of sales with each month. Now I have to create this sum, but based on the size of the project (% share of costs in the total). First we take the largest project, then add a smaller and smaller one to it... The table has to show the 10 largest projects. The table is also to be filtered by various filters, such as the date, so the project position cannot be set hard. If, for example, each project was permanently assigned a rank (in PQ or a calculated column in DAX), then the filter will not work on this rank. The largest project in January may already be finalized in February and may not appear in the data from February at all. Therefore, everything has to be dynamic. Below is a table showing how it should look like. Anyone have any idea how to come to this? (P.S. Cost and Cost% are DAX measures).
