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 ...
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)

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)