m_vishal_c
Board Regular
- Joined
- Dec 7, 2016
- Messages
- 209
- Office Version
- 365
- 2016
- Platform
- Windows
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
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 |
