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)

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)