Count total number of children in the Hierarchy

[cutestjigs]

Hello!

I have accounts table, it contains id, name, parent_id, path, subscription start date, subscription end date. I'm trying to get 2 numbers.
1) No. of Valid SubMerchants = Count total number of children (next level) under the account which subscription is not expired within particular period. 
2) No. of Valid Tree Sub Merchants = Count total number of children (including children's children (all level)) under the account which subscription is not expired within particular period.

Both number should be dynamic based to the period selected in calender.

I am able to get No. of submerchants = Count total number of children (next level) under the account (but i'm not able to filter it according to calender period and subscription period).

Many Thanks,

Jigu Patel

[v-piga-msft]

Hi @cutestjigs,

Have you have another Calendar Table?

If it is convenient, could you share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)

Best Regards,

Cherry