Hi, glad to join the community. We are trying to implement a global report (gauge chart, only values format) with some measures affecting multiple projects . For instance:
Projects count
Initiatives count
Epics count
Project dimension is being used as a page filter. Initiatives and Epics measures work fine. But Projects measures don´t work properly. We´ve tried the following alternatives for Projects count measure:
Hi @JJS
The measures work as designed because the first (a) counts all members of the project dimension. The second measure (b) takes into account the CurrentMember selection thus is counting the project selection, but it cannot when multiple projects are selected.
You can try this measure to count project that have been selected in Pages:
With this improvement, the multiple selection scenario works fine now, but if you select only 1 project it counts the number of components under the selected project. Is there any alternative to address this behaviour?