RANKX in Matrix Drilldown

[davidmg1982]

Evening, im looking for some guidance on how to keep adding filtering levels to this piece of code:


Rank by OrderQty =
VAR IsProductFiltered = ISFILTERED('Product'[Product Name])
VAR IsProductCategoryFiltered = ISFILTERED('Product'[Product Category])
VAR IsProductClusterFiltered = ISFILTERED('Product'[Cluster])
RETURN
IF (IsProductFiltered && IsProductCategoryFiltered && IsProductClusterFiltered,
RANKX(ALL('Product'[Product Name]), CALCULATE(SUM('Product'[OrderQty]))),
IF (NOT IsProductFiltered && IsProductCategoryFiltered && IsProductClusterFiltered,
RANKX(ALL('Product'[Product Category]), CALCULATE(SUM('Product'[OrderQty]))),
IF (NOT IsProductFiltered && IsProductCategoryFiltered && IsProductClusterFiltered,
RANKX(ALL('Product'[Cluster]), CALCULATE(SUM('Product'[OrderQty]))),
BLANK()
)
))


I have created two measures with ISFILTERED function for ISFILTERED('Product'[Product Name]) and ISFILTERED(ProductCategory[Product Category]), so far is working very good, but if need to add lets say ISFILTERED(ProductCategory[Country]) and ISFILTERED(ProductCategory[Product Region]), how can I add this to the existing code after adding the new variables.

Thanks ahead for all your help!

[/CODE]

 

[davidmg1982]

Nevermind I just catch the logic