Running Totals Added Together to produce a forcast
Hi, Im trying to add together 2 RT Totals but cant seem to figure it out 😞 I have a running total in one table for the Actuals (P6_PowerBI_Actual_Labor_Units) Calculation: P6_RT_Actual_Labor_Units = CALCULATE(SUM(P6_PowerBI_Actual_Labor_Units[Value]),FILTER(ALLSELECTED(PowerBI_Date[Date]),PowerBI_Date[Date]<=MAX(P6_PowerBI_Actual_Labor_Units[Date]))) And another table for the remaining hours (P6_PowerBI_Remaining_Labor) Calculation: P6_RT_Remaining_Labor = CALCULATE(SUM(P6_PowerBI_Remaining_Labor[Value]),FILTER(ALLSELECTED(PowerBI_Date[Date]),PowerBI_Date[Date]<=MAX(P6_PowerBI_Remaining_Labor[Date]))) Both tables are joined together with a Date table PowerBI_Date. Current results if i sum both together. Intended Result. Any help would be appricated, Thanks in Advance.
Running Total
Hi I have a table named 'Kartela' with posting date and amount i need to build a measure according to other solutions in the comunity but it does not completely work . When I keep the table simple it works but when i add more info like the remarks of the movement is not working any idea how to fix it ? thea measure is Running Total = Calculate ( SUM(kartela[blc]), FILTER( ALL('kartela'[Posting Date] ),'kartela'[Posting Date] <= MAX('kartela'[Posting Date])))
Acummulated tickets along time - Show acummulated after today - Cumulative Totals
Hi guys, I need your help... I'm trying to show the accumulated open tickets along the months, but on visuals they extend until december. I would like to see until the current month, I have try almost everything, but not worked, even the ChatGPT could give me a good answer. You are my last hope. I use this measure: CALCULATE ( CALCULATE ( COUNTROWS ( f_Suporte ), FILTER ( ALL ( f_Suporte[##Related Status_Cliente] ), f_Suporte[##Related Status_Cliente] = "Ativo" ), FILTER ( ALL ( f_Suporte[##StatusTicket] ), f_Suporte[##StatusTicket] = "ABERTO" ) ), FILTER ( ALL ( Date_Table_TR[Date] ), Date_Table_TR[Date] <= MAX ( Date_Table_TR[Date] ) ) )
Running total using datediff in a measure
I need a dynamic measure that can make a running total summing the amount of days between two dates per employee. I want the measure to be able to run in 12 months 'windows'. Please regard I am not able to use window functions since i use analysis services which doesn't include window functions. This is the data: Among other attempts I have tried: Running total = CALCULATE( sumx( SUMMARIZE('Data', "result", DATEDIFF(MAX('Data'[Date incurred]), MIN('Data'[Date paid]), DAY )) , [result]) , DATESINPERIOD('Data'[Date paid], MAX('Data'[Date paid]), -1, YEAR)) Anybody know of a solution where one can make running totals like that without using window functions?Running Total not working correctly on Custom Tooltip
Hi All, I have a Running Total measure _ActualCost Test RT that works correctly on a Column chart and a table visual, but when placed onto a custom tooltip to show the data for the column chart visual it seems to only provide the month value. So for the month of September FY 2023 the _ActualCost Test RT should be displaying $7,837,046 but the tooltop is showing $2,291,617. Note: The reason I need a custom tooltip is because I need to use a clustered column chart. _ActualCost = CALCULATE( SUM(ZISU_RPT_DCSTRV[AMOUNT]), FILTER('GL ACCOUNT HIERARCHY', 'GL ACCOUNT HIERARCHY'[Revenue]=BLANK() && LEFT('GL ACCOUNT HIERARCHY'[G/L Account Name],3) <> "ASS" && 'GL ACCOUNT HIERARCHY'[G/L Account Grouping] <> "Settlements")) _ActualCost Test RT = CALCULATE( [_ActualCost], FILTER( CALCULATETABLE( SUMMARIZE('DimDate', 'DimDate'[Fiscal Year], 'DimDate'[FY Fiscal Year], 'DimDate'[Fiscal Period], 'DimDate'[MonthNameLong]), ALLSELECTED('DimDate') ), ISONORAFTER( 'DimDate'[Fiscal Year], MAX('DimDate'[Fiscal Year]), DESC, 'DimDate'[FY Fiscal Year], MAX('DimDate'[FY Fiscal Year]), DESC, 'DimDate'[Fiscal Period], MAX('DimDate'[Fiscal Period]), DESC, 'DimDate'[MonthNameLong], MAX('DimDate'[MonthNameLong]), DESC ) ) )Get count of rows in running total measure
Hello, I am a beginner in Power BI and I have a problem calculating the number of occurrences of measure. I have 2 problems : 1) I want to know the number of distinct item items I have in measure "Difference Running Total A & B" Example, in my table , i have 2 article in september 2023. Which formula dax i can do ? 2) I want to know the number of items difference from zero in measure "Difference Running Total A & B" in my example, i have 2 article with difference running total A&B <>0 My data it's Year, Month, Article and Storage. I calculate Running total A, Running total B and Difference Running Total A&B in Power bi with measures Running total A = CALCULATE( SUM( 'Table'[QuantiteA] ), FILTER( ALLSELECTED( 'CALENDAR' ), 'CALENDAR'[Date] <= MAX('CALENDAR'[Date] ) )) Running total B = CALCULATE( SUM( 'Table'[Quantite B] ), FILTER( ALLSELECTED( 'CALENDAR' ), 'CALENDAR'[Date] <= MAX('CALENDAR'[Date] ) )) Difference Running Total A&B = [Running total A] - [Running total B] My data model : To better understand my problem, I created a pbix file which can be downloaded via One Drive : https://1drv.ms/u/s!AjUN6-w6YnuGz1ng157xR5Ha7h_x
