11.动态排名

情况一

Test RankX = 
    IF(
        HASONEVALUE(DimProducts[Name]),
        RANKX(
            ALLSELECTED(DimProducts[Name]),
            [销售：销售额.合计 simple]
        )
    )
//----------------------------------------------------------------------//    
Test RankX 2 = 
    IF(
        HASONEVALUE(DimProducts[Name]),
        RANKX(
            ALL(DimProducts[Name]),
            [销售：销售额.合计 simple]
        )
    )

情况二

销售：销售额.合计.排序 = 
    IF(
        HASONEVALUE(DimProduct[Color]),
        RANKX(
            ALLSELECTED(DimProduct[Color]),
            [销售：销售额 合计]
        )
    )
销售：销售额.合计.排序 CrossJoin Region and Color = 
    var ColorAndRegion=CROSSJOIN(ALL(DimSalesTerritory[SalesTerritoryRegion]),ALL(DimProduct[Color]))
    return 
        RANKX(
            ColorAndRegion,
            [销售：销售额 合计]
        )

cross join.jpg