cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

## Sum of a column with repeating values - DO NOT DISPLAY

Hi

In the attached how would I not display the sum value 837418.20 for the rest of the days where there are no actual values yet? Please see THE FORMULA BELOW  and you would understand what I am trying to do.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support

## Re: Sum of a column with repeating values - DO NOT DISPLAY

Hi @venunm,

>>Hi do you know how you got the 'current' in you formula? and what is dates?

"Current" is the " New Column.Disbursed Advance Amount" column, "Data" field has auto analyzed to date hierarchy.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
14 REPLIES 14
Highlighted
Community Champion

## Re: Sum of a column with repeating values - DO NOT DISPLAY

@venunm

hi, Transform your dax to this:

Measure=IF (Column <>Blank(),Calculation, Blank())

And Measure is Total PP This Month

Lima - Peru
Highlighted
Frequent Visitor

## Re: Sum of a column with repeating values - DO NOT DISPLAY

Hi thanks for getting back to me on this. What is 'calculation' in the If statement you used below?

Also my NewColumn.Disbursed Advance Amount is not populating when I start the formula?

Highlighted
Community Champion

@venunm

try this:

Lima - Peru
Highlighted
Frequent Visitor

## Re: Sum of a column with repeating values - DO NOT DISPLAY

Hey still not getting thru...I might be doing something really silly....Please see below

Column = IF(CALCULATE(sum(Merge1[NewColumn.Disbursed Advance Amount])<>BLANK),CALCULATE(sum(Merge1[NewColumn.Disbursed Advance Amount]),FILTER(ALL(Merge1),Merge1[Days into Quarter]<MAX(Merge1[Days into Quarter]))); BLANK()

Highlighted
Community Champion

## Re: Sum of a column with repeating values - DO NOT DISPLAY

@venunm

Try changing this to simplify the dax formula:

```Mymeasure =
VAR SumDAA =
CALCULATE ( SUM ( Merge1[NewColumn.Disbursed Advance Amount] ) )
RETURN
IF (
[SumDAA] <> BLANK (),
CALCULATE (
[SumDAA],
FILTER (
ALL ( Merge1 ),
Merge1[Days into Quarter] < MAX ( Merge1[Days into Quarter] )
)
),
BLANK ()
)```

Lima - Peru
Highlighted
Frequent Visitor

## Re: Sum of a column with repeating values - DO NOT DISPLAY

it says the value for 'SUMDAA' cannot be determined. Either 'SumDAA' doesnt exist, or there is no current row for a column named 'SumDAA'?

I have tried using both new measure and new column.

Highlighted
Community Champion

## Re: Sum of a column with repeating values - DO NOT DISPLAY

yeah sorry, delete [] from SumDAA

Lima - Peru
Highlighted
Community Support

## Re: Sum of a column with repeating values - DO NOT DISPLAY

Hi @venunm,

Can you please share us a sample file to test?

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Highlighted
Frequent Visitor

## Re: Sum of a column with repeating values - DO NOT DISPLAY

Hi, so as you can see from the above, the 'My measure' formula is doing the job of not repeating the max value till 31st January but adding up incorrectly. It should be cumulative i.e. Jan 4th should start from 41,000, Jan 5th should be newcolumn.disbursed advance amount 168,139.69 + 41,000 = 209,139.69 and so on. The values should be same as the 'Total PP this month' column. Is it something to do with the formula?

Formula used is:

My Measure = VAR SumDAA =
CALCULATE ( SUM ( Merge1[NewColumn.Disbursed Advance Amount] ) )
RETURN
IF (
SumDAA <> BLANK (),
CALCULATE (
SumDAA,
FILTER (
ALL ( Merge1 ),
Merge1[Days into Quarter] < MAX ( Merge1[Days into Quarter] )
)
),
BLANK ()
)

Announcements

#### Power Platform Community Conference

Check out the on demand sessions that are available now!

#### Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

#### Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021