Hide drop-downs from pages on dashboard

[jrjanis]

Hi Janis,
I’m looking to do something similar but without having to create so many calculated members.

My goal is a report that shows sprint story point activity for the last 8 closed sprints. For example:

However, in our case there are something like 65 teams (boards). Ideally I would be able to select a Board in a Page filter and only need 1 report. I haven’t managed to be able to configure this, though. The approach I’ve taken would require 65 calculated members and 65 separate reports. I guess I can live with 65 reports but creating the 65 calculated measures is not desirable. I would be happy with a list of all of the last 8 closed sprints from all boards but grouped by board. Then, at least I can select just the board I want for the report and expand it to get the sprints.
I’ve only managed to either get a list of the sprints (without the boards), or the boards with all of the sprints.

For instance, I end up with this (the boards I want but with all the sprints):

…or this (the sprints I want but for ALL boards, including boards I don’t want, and not grouped by board):

This has been my approach. I have a calculated member that aggregates the team boards I’m interested in, as such:

Aggregate(
  {
   [Sprint].[Team Board 1],
   [Sprint].[Team Board 2],
   [Sprint].[Team Board 3]
   }
)

This gives me the results in the first picture (All team boards). I need to do this because there are boards that are imported that I do not want to report on.

My other attempt was to create a calculated member that filtered out the last 8 closed sprints but this gave me the results in the second picture (Last 8 closed sprints). Like this:

Aggregate(
  Generate(
    [Sprint].[Board].Members,
    Tail(
      Filter(
      [Sprint].CurrentMember.Children,
      [Sprint].CurrentMember.GetBoolean("Closed")),
      -- last 8 closed sprint in the board
      8)
  )
)

I am trying to change the set expression in the Generate function to give me those last 8 sprints but grouped by board like in the other calculated member (e.g., [Sprint].[All team boards].Children) , but that doesn’t work - in fact, nothing is returned.

Is what I’m trying to do even possible? This is a recurring issue for me as I want to do many reports besides sprint story point activity and I keep running into the same issue.

Any suggestions for a different approach would be greatly appreciated.

Regards,
-jj