Forum Discussion

rajuctech's avatar
rajuctech
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 here the “Total” is showing it’s coming automatically, I need to be calculated manually [ L1 to L7] like wise [L3 to L7] sum.

Thanks | Raju

Need Help
  • YukiK's avatar
    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"
    )
)

     

3 Replies

  • YukiK's avatar
    YukiK
    Impactful Individual
    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"
    )
)

     

    • YukiK's avatar
      YukiK
      Impactful Individual
      4 years ago

      Glad it's helpful! Please don't forget to give it a thumbs up and accept as a solution:)