cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

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.

 

Clientes.jpg

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

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
Community Support Team

Re: Total Indicator without Date

Hi @MiguelSaldana77

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

Could you give more detailed information?

 

Best Regrads

Maggie

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.

 

Customer.jpg

Highlighted

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.

Helpful resources

Announcements
Virtual Launch Event

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

Power BI Helps Homeless and Trouble Youth

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

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 77 members 1,145 guests
Please welcome our newest community members: