calculation sum per day per administration

[EdJ]

Hi, I have an issue I'm trying to work through. 

I have a list which is updated daily of bank balances, with numerous bank accounts of multiple administrations.

I have made a new table to calculate the sum of amount per day per administration. 

Berekeningen = SUMMARIZECOLUMNS(  Dagsaldo[Datum_bankafschrift], Dagsaldo[administratienaam],  "Sum of Amount",SUM(Dagsaldo[Dagsaldo per bankrekening]) )

Q1: visual line dot

I have a visual line dot with daily bank balances including a drop down select filter by administraton: works ok. But I would like to ad the sum of bank balances per day which also filters when selecting one or multiple administrations.

Q2: calculation

For a simple calculation I need the sum of bank balances per last day which also filters when selecting one or multiple administrations by drop down select filter.

[Anonymous]

@EdJ 
For more help, maybe share a sample pbix without sensitive information.

Paul

[amitchandak]

@EdJ , sum of bank balances per last day is a measure. You need to consider binning or segmentation using an independent table

refer

https://www.daxpatterns.com/dynamic-segmentation/
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization

My video: https://www.youtube.com/watch?v=CuczXPj0N-k