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

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

@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

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

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

@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

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

yeah sorry, delete [] from SumDAA

Lima - Peru
Highlighted
Community Support

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

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!

#### Microsoft Power Platform Communities

Check out the Winners!

#### Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors