Forum Discussion

umanbr's avatar
umanbr
Frequent Visitor
7 years ago
Solved

Drill down measures

Hi all, I have a measure value which is calculated as measure1+ measure 2+ measure3 And measure1 is aggregate of 3 sub categories and measure2 has 4 subcategories. I want to represent these values i...
  • v-lili6-msft's avatar
    7 years ago

    hi, umanbr 

    After my research , I'm afraid it couldn't achieve in Power BI for now.

    although the measure is calculated as measure1+ measure 2+ measure3

    But it's essentially one formula, 

    for example:

    Measure =measure1+ measure 2+ measure3

    Measure =COUNTA([Value]) + Max([Value]) + Min([Value])

    How do you dirll down this measure.

     

    But as a workaround, you could use Bookmark to get a similar effect, here is a blog for you refer to:

    https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive

     

    For one bookmark, it shows Measure with visual

    and another bookmark, it shows measure1, measure 2, measure3 with visual

    Then you use bookmark for "Drill down"

     

    Best Regards,

    Lin