Forum Discussion

hnb_tor's avatar
hnb_tor
Frequent Visitor
2 years ago
Solved

calculated column to aggregate based on two columns

  Hi ,   I'm looking for some help in writing DAX to create a Calculated column with the below requirements -    Below table contains Customer, Department, Region and number of Orders.  I want ...
  • dharmendars007's avatar
    dharmendars007
    1 year ago

    Hello hnb_tor , 

     

    Please try the below formula its more simpler..

     

    CALCULATED COLUMN =
    CALCULATE(SUM('Table'[Orders]),ALLEXCEPT('Table', 'Table'[Customer], 'Table'[Region]))

     

     

    If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes are much appreciated!

     

    Thank You

    Dharmendar S

    LinkedIN 

     

dharmendars007's avatar
dharmendars007
Icon for Memorable Member rankMemorable Member
1 year ago

Hello hnb_tor , 

 

Please try the below formula its more simpler..

 

CALCULATED COLUMN =
CALCULATE(SUM('Table'[Orders]),ALLEXCEPT('Table', 'Table'[Customer], 'Table'[Region]))

 

 

If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes are much appreciated!

 

Thank You

Dharmendar S

LinkedIN 

 

  • hnb_tor's avatar
    hnb_tor
    Frequent Visitor
    1 year ago

    thanks so much, this solution worked!