Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi, I am trying to create a measure in DAX where I calculate different totals based on a hierarchy-level using the InScope function.
This is what my measure looks in DAX :
And this is what the results looks like :
Projects | 82 |
Boards | |
Board Name (1) | 5 |
Board Name (2) | 42 |
Board Name (3) | 82 |
Sprints |
The problem I have is regarding the hierarchy 1, Projects, instead of summing the numbers of the boards (board 1, board 2, board 3), I only get the result of the board 3, 82.
What I want is summing all boards at the project level, so I am asking if someone would have a solution on this one.
Thank you,
Please provide sanitized sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.
User | Count |
---|---|
77 | |
76 | |
42 | |
30 | |
24 |
User | Count |
---|---|
97 | |
91 | |
52 | |
47 | |
46 |