User Profile
RNair
Helper I
Joined 5 years ago
User Widgets
Contributions
Re: Total en ejecución agrupado en una medida
@amitchandak, @MFelix y otros, Pude crear la salida que necesitaba usando una variable. Salida requerida recibida de la siguiente manera. La medida **bleep** Valor por serie se definió de la siguiente manera. **bleep** Valor por serie ? Serie VAR á [SeriesID] devolución CALCULATE(SUM(Sheet1[Value]), FILTER(ALLSELECTED(Sheet1), Sheet1[Date] <- MAX(Sheet1[Date]) && [SeriesID] á Series)) Gracias por todo el apoyo. Los comentarios recibidos en el foro me han ayudado a llegar a la solución. saludos RamesanRe: Running Total grouped on a measure
amitchandak , MFelix and others, I was able to create the output I needed by using a variable. Output required received as follows. The measure **bleep** Value by Series was defined as follows. **bleep** Value By Series = VAR Series = [SeriesID] Return CALCULATE(SUM(Sheet1[Value]), FILTER(ALLSELECTED(Sheet1), Sheet1[Date] <= MAX(Sheet1[Date]) && [SeriesID] = Series)) Thank you for all the support. Feedback received in the forum has helped me to get to the solution. Regards, RamesanRe: Running Total grouped on a measure
amitchandak From Qty column you calculate a running total called QtyAft. Sometimes the QtyAft becomes zero. QtyAft = CALCULATE(sum(Sheet1[Qty]), FILTER(ALLSELECTED(Sheet1), Sheet1[Date]<= MAX(Sheet1[Date]))) Initially SeriesID is 1. Whenever the QtyAft reaches 0, Series ID changes for the next transaction. So SeriesID is SeriesID = VAR ListOfZeros = FILTER(ALLSELECTED(Sheet1), [QtyAft] = 0 && Sheet1[Date] <= MAX(Sheet1[Date])) Return IF([QtyAft]= 0, CountRows(ListOfZeros), CountRows(ListOfZeros) +1 ) Regards, RamesanTotal en ejecución agrupado en una medida
@MFelix y otros, He adjuntado un archivo pbix en la ubicación de onedrive a continuación. https://1drv.ms/u/s!Aqc2e7y3QZN5mFH_F1YA9aJ7q1le?e=J2Y78g Las 1a 4 columnas son datos sin procesar. SeriesID es una medida. Ahora quiero crear un total en ejecución en Value pero agrupado por SeriesId. Así que el resultado se verá así. Necesito crear la última columna como medida. saludos RamesanRunning Total grouped on a measure
MFelix and others, I have attached a pbix file at the onedrive location Below. https://1drv.ms/u/s!Aqc2e7y3QZN5mFH_F1YA9aJ7q1le?e=J2Y78g The 1st 4 columns are raw data. SeriesID is a measure. Now I want to create a running total on Value but grouped by SeriesId. So the result will look like this. I am needing to create last column as a measure. regards, Ramesan
