Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
AtulSutar
New Member

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.

1 ACCEPTED SOLUTION
BA_Pete
Super User
Super User

Hi @AtulSutar ,

 

Try a measure like this:

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

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




View solution in original post

1 REPLY 1
BA_Pete
Super User
Super User

Hi @AtulSutar ,

 

Try a measure like this:

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

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors