cancel
Showing results for
Did you mean:
Member

## 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
Highlighted
Member

## 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

Member

## 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.

Highlighted
Member

## 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

#### Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

#### Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 47 members 1,166 guests
Recent signins: