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
    2 years 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
2 years ago

Hi, Thanks again for helping on this request. 

I cant open the pbix file you have shared, there is a message that my PowerBI Desktop version is not compatiable with some of the features on this file. 
I'm going to see if I can get PowerBI desktop client upgraded on my computer and test if I can try your solution. Thanks, 

hnb_tor's avatar
hnb_tor
Frequent Visitor
2 years ago

Sorry, I havent yet upgraded the version, will upgrade and test soon.