Forum Discussion

aaron797's avatar
aaron797
Advocate I
6 years ago

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 drill through for my chart, currently, when you right click "Finance - Drill through" in a chart, it comes up with all the different KRAs, when you click finance, it will successfully take you to the finance page, however if you right click finance, and go to KRA: Employee the table will be blank.

 

How to I tidy this up, Ideally, when right clicking "Finance - Drill through" only the finance report should come up. etc.

 

Need Help

1 Reply

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    6 years ago

    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.