cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
MiguelSaldana77 Regular Visitor
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.

 

Clientes.jpg

1 ACCEPTED SOLUTION

Accepted Solutions
MiguelSaldana77 Regular Visitor
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
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

MiguelSaldana77 Regular Visitor
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.

 

Customer.jpg

MiguelSaldana77 Regular Visitor
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.

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 229 members 2,156 guests
Please welcome our newest community members: