cancel
Showing results for
Did you mean:
Regular Visitor

## Total Indicator without Date

Hi, I'm looking for a formula to calculate a Total of an Indicator excluding dimension of time.

I have a table that shows a Balance today for each Costumer and I make a Drill-Down see the correspondent bill.  I need to see the sum of charges and the payments for this each Bill.

1 ACCEPTED SOLUTION

Accepted Solutions
Regular Visitor

## Re: Total Indicator without Date

This is the Final Formula

Cumulative Cargos = CALCULATE ( SUM ( 'Indicadores Cartera'[Cargo] ),
FILTER ( ALL( 'Cat Tiempo'[Fecha] ),'Cat Tiempo'[Fecha]<= MAX ('Cat Tiempo'[Fecha])))

I had problems with the data but not because the formula.

3 REPLIES 3
Community Support Team

## Re: Total Indicator without Date

I can't find how to calculate the sum of charges and the payments for this each Bill.

Could you give more detailed information?

Maggie

Regular Visitor

## Re: Total Indicator without Date

Ok, This is an Example

I need always the Sum of The Charge for the Correspondent Bill

The same for the Payments (for the correspondent bill)

I want to exclude the date for the sum of Charges and Payments , of course I need Charges and Payments for the correspondent Bill.

Regular Visitor

## Re: Total Indicator without Date

This is the Final Formula

Cumulative Cargos = CALCULATE ( SUM ( 'Indicadores Cartera'[Cargo] ),
FILTER ( ALL( 'Cat Tiempo'[Fecha] ),'Cat Tiempo'[Fecha]<= MAX ('Cat Tiempo'[Fecha])))

I had problems with the data but not because the formula.

Announcements

Power BI Super User, Greg Deckler, explains

#### Power Platform Summit North America

Register by September 5 to save \$200

#### Back to School Contest

Engage and empower students with Power BI!

#### Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Top Kudoed Authors
Users Online
Currently online: 35 members 979 guests
Recent signins: