Forum Discussion
Drilldown Then Filter Help
I have a pie graph where there are 5 groups. Let us call them group 1 - group 5, then when i drill down in those groups I have supplier level which has multiple suppliers in each of the groups (The v...
Hi
There is a way you can create a measure displaying the TOP N values that are in a dimension scope.
Have bellow an example for 2 dimensions, you can just add your own.
Top 8 Sales =
var _top = 8
RETURN
SWITCH (
TRUE (),
ISINSCOPE ( 'youtable'[group 2] ) && ISINSCOPE ( 'youtable'[group 1] ),
CALCULATE(
[Sales],
KEEPFILTERS(
TOPN(
_top,
ALL('youtable'[group 2]),
[Sales]
)
)
),
ISINSCOPE ( 'youtable'[group 1] ),
CALCULATE(
[Sales],
KEEPFILTERS(
TOPN(
_top,
ALL('youtable'[group 1]),
[Sales]
)
)
)
)
Kind regards,
José
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂
Anonymous I think this is on the right track... The issue is a little different though. The table is 'All Mappings' [ABC] where within [ABC] there is "group 1, group 2... etc" the groups are within the same column. look below to see if it better explains. I think your formula is in the right direction.
- 'All Mappings' [ABC]
- it contains "group 1, group 2, group 3, etc"
- drill down and you have [Supplier]
- it contains a lot of suppliers "supplier a, supplier b, etc"
- Depending on which group i drilldown into i was the top however many supplier by sales within that specific group.
The issue I run into is that filtering by TopN only gives the top suppliers in total and not by the group i have drilled down on.