how to get count of subfolders and files on Silcer selection Power bi

[m_vishal_c]

HI before i start, i have also post same concept question on here but for Excel.
I am looking the solution for power bi.

i do have all folders and files complete path in column ( i fetch data from excel:- data source).
from that i have created slicer and i need count of all subfolders and files (on PowerBi-Cart) on selected value in slicer. like

if i select
(1) "General" from slicer, it should gives me count like 17 (as per below image),
(2) If i select General/ABC then it counts 9 (including subfolders)
(3) if i select General/ABC/ABC1 then the count will be 7

can anyone help me. thanks in advance...

if this is duplicate with my previous ( as i mentioned in beginning) please let me know so i can delete one of them. thanks

Path

General

General/ABC

General/ABC/ABC1

General/ABC/ABC1/ABC1 - Report1/1212.xls

General/ABC/ABC1/ABC1 - Report2

General/ABC/ABC1/ABC2

General/ABC/ABC1/ABC2/Fun 2022

General/ABC/ABC1/ABC2/ABC3

General/ABC/ABC1/ABC2/ABC3/ABC4

General/ABC/ABCDE

General/XYZ

General/XYZ/MARSH

General/XYZ/MARSH/EARTH

General/XYZ/LAND

General/XYZ/LAND/HOUSE

General/XYZ/LANDSCAPE

General/XYZ/LANDSCAPE/BIKE