Forum Discussion

Frequent Visitor

4 years ago

Solved

Category level sum

Hi Team, I need a category wise level sum am a beginner for Power BI, the attached PBI Report needs to be calculate L1 to L7 sum also I need a one more measure it should be L3 to L7 sum. As of now...

Need Help

YukiK

4 years ago

This may be what you're looking for.

Sum of Canada & France = 
CALCULATE(
    SUM(financials[ Sales]),
    KEEPFILTERS(
        financials[Country] = "Canada" ||
        financials[Country] = "France"
    )
)