Forum Discussion

erhan_79's avatar
erhan_79
Post Prodigy
6 years ago
Solved

formula help sumif

Hi there , 

 

i need your a small help pls 

 

i have a table which one name is "Table A" as below , i just would like to calculate on somwhere only "sales group " = C  total somwhere , it should be a measure , could you pls say the formula to calculate pls 

 

thanks in advance 

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi erhan_79 ,

     

    Try this measure

     

     

    measure =
    CALCULATE(
    SUM('Table'[Amount]
    )
    , 'Table'[Sales Group] = "C"
    )
     

    Regards,
    Harsh Nathani

    Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

3 Replies

  • az38's avatar
    az38
    Community Champion
    6 years ago

    Hi erhan_79 

    you don't need any coding, just put in table visuals Amount field and set aggregation

    or create a supersimple statement like

     

    SUM(Table[Amount])

     

    or, for more complicated data models

     

    CALCULATE(SUM(Table[Amount]), ALLEXCEPT(Table, Table[Sales Group]) )

     

     

    • erhan_79's avatar
      erhan_79
      Post Prodigy
      6 years ago

      Dear az38 

       

      Thanks for your repy , used your formula as below 

       

      CALCULATE(SUM(Table[Amount]), ALLEXCEPT(Table, Table[Sales Group]) )

       

      but when i use like that that measure is calculating based on all sales group , i just need Sales group C 's total because i need to use that totally in another visual  

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi erhan_79 ,

         

        Try this measure

         

         

        measure =
        CALCULATE(
        SUM('Table'[Amount]
        )
        , 'Table'[Sales Group] = "C"
        )
         

        Regards,
        Harsh Nathani

        Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)