Forum Discussion
aaron797
6 years agoAdvocate I
Drill through Multiple Values
Hi, I have setup a page for each KRA (Finance, Facility and Equipment, Stakeholders etc), and have linked the field "KRA is Finance" in the drill through on the finance page. I am trying to setup ...
v-lionel-msft
6 years agoCommunity Support
Hi aaron797 ,
This happens because you create multiple pages and add the KAR field to 'drillthrough bucket' of each page:
You can only keep two pages.
Or create measures for each page and use the measure instead of KAR column:
// use the measure insteading of KAR column, including value bucket and drillthrough buctet.
Measure 2 =
CALCULATE(
SUM([Value]),
FILTER(
Sheet3,
[KRA] = "Finance"
)
)
Measure 3 =
CALCULATE(
SUM([Value]),
FILTER(
Sheet3,
[KRA] = "Facility and Equipment"
)
)
Measure 4 =
CALCULATE(
SUM([Value]),
FILTER(
Sheet3,
[KRA] = "Stakeholders"
)
)
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.