Assistance with Waterfall Visualization

Hello v-zhenbw-msft 

I appologize as I thought this reply went out yesterday, but I guess there were some issues I didn't see until today.

Thanks again for your help on this. That looks like a brilliant solution, however the partitioning for policy number is not considered.  I would like to attach an example, but I can't figure out how to remove credentials from our database.

I have the start and end numbers working fine, it is the in between steps that are causing me issues.  Here are my measures for Start and End counts - note I'm using  the datavitz waterfall chart, which allows me to add a dedicated start and end measure :

Start Count = calculate(COUNTA([PolicyKeyStart]),filter('Fact Policy Transactions','Fact Policy Transactions'[AsOfDateKey]=MIN('Dim As Of Date'[DateKey])))


End Count = calculate( counta([PolicyKeyEnd]),filter('Fact Policy Transactions','Fact Policy Transactions'[AsOfDateKey]=MAX('Dim As Of Date'[DateKey])))

 I do not have to use that vizualization, but the fact that Start and End counts are seporated, it made it easier for me. I can see how your solution utilizes the included waterfall chart, which will save us money.

not sure if this will help, but I'm trying to get fact table that filters dynamically with the date dimensions and where the transaction type by  and net by policy where : 

rank() over (partition by policy order by datekey asc) rnk where rnk=1 and   sum(net policies) over (partition by policy) =1

unioned with

rank() over (partition by policy order by datekey desc) rnk where rnk=1 and sum(net policies) over (partition by policy) =1 =-1

Here is my fact table:

Dimensions are in the previous post.

Thanks again for helping out. I'd be happy to provide additional clarification.

Best regards