Forum Discussion

AtulSutar's avatar
AtulSutar
New Member
3 years ago
Solved

New measure Dax formula needed

I have OLAP source file and in that file, I want to have the sum of the particular item group. 

 

e.g. there are many item groups like 72absc, 72dmap, 40abds, 23asrt and there is sales value for these group.

 

I need sum of values only for 72dmap item group.

 

Kindly help.

Need Help
  • BA_Pete's avatar
    BA_Pete
    3 years ago

    Hi AtulSutar ,

     

    Try a measure like this:

    _72dmapSales =
CALCULATE(
    SUM(yourTable[Sales]),
    yourTable[Item Group] = "72dmap"
)

     

    Pete

1 Reply

  • BA_Pete's avatar
    BA_Pete
    Icon for Super User rankSuper User
    3 years ago

    Hi AtulSutar ,

     

    Try a measure like this:

    _72dmapSales =
CALCULATE(
    SUM(yourTable[Sales]),
    yourTable[Item Group] = "72dmap"
)

     

    Pete