image.png

    1. 销售:销售额.分区间 合计 =
    2. if(
    3. ISFILTERED(DimRank[RankName]),
    4. CALCULATE(
    5. [销售:销售额 合计],
    6. var minV = VALUES(DimRank[MinPrice])
    7. VAR maxV = VALUES(DimRank[MaxPrice])
    8. RETURN FILTER(
    9. DimProduct,
    10. AND(
    11. DimProduct[ListPrice]>=minV,
    12. DimProduct[ListPrice]<maxV
    13. )
    14. )
    15. )
    16. )