I have data set with hierarchy column with Categoy and Prodcut .I know how to create TOP N rank fornuciotn for one field name.But when I create one hierarchy and drill down the level my top N formula is not applying to next level.For example I have created the TOP N using category field .But in my chart I have put the hierarchy .before drill down I am getting top 2 as categroy in my chart.But when I drill down chart I am in procut level there I am not getting the top 2 within the product for that category.Because my top n rank dax is on the basis of categroy. Is there is any opton to expand my top n ranks funciton to hierarchy level aswell intead of category level. when everuser drill down the category he shoul see top n within that category
| Category | Product | Sales |
| Tooth paste | Colgate | 100 |
| Tooth paste | Cibaca | 70 |
| Tooth paste | Dabur | 50 |
| Cosmetic | Ponds | 20 |
| Cosmetic | Liril | 16 |
| Cosmetic | Cuttikoora | 20 |
| Cosmetic | Mice | 31 |
| TV | Samsung | 400 |
| TV | Onida | 3000 |
| TV | Sony | 300 |
| TV | SunTV | 200 |
| TV | Mono | 200 |
