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

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: 6 members 3,802 guests
Recent signins: