Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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.
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.
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |