Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
in a matrix I'd like to display all Account data that have "child" or "parent" account. So I create PATH-functions as columns:
So in this case, the first two Account numbers (Path lev 1) with their child account numbers (Path lev 2) AND the blank row should be displayed. All other Account numbers should not be seen.
The difficult part for me is to show these blank rows as well while other Accounts who don't have a child-account should disappear.
Thank you.
Solved! Go to Solution.
@thhmez7 , refer if this can help
or
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
@thhmez7 , refer if this can help
or
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |