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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
aartiladdha
Employee
Employee

Summing column values based on slicer selection

I have a table with 2 fields, Plant group and capacity. When I am using plant code as a slicer, I want the capacity to sum up accordingly. See below, if I choose *787 & *245 as plant group, I would want the capacity to show up as 30000 in my visual. Capture.PNG

 

2 ACCEPTED SOLUTIONS
Nathaniel_C
Super User
Super User

Hi @aartiladdha ,

Create a measure = SUM(table[Capacity]) and drop it on a Card. Select the [Plant Group ]as Slicer.
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

Washivale
Resolver V
Resolver V

Hi @aartiladdha ,

 

Create measures as below to understand outcome behaviour on slicer selection

 

Measure1 = Sum(Table[Capacity])

Measure2 = Calculate(Measure1, ALL(Table[Plant Group]))

Measure3 = Calculate(Measure1, ALLSELECTED(Table[Plant Group]))

 

let me know if it helps,

 

Regards,

Washivale

 

 

View solution in original post

7 REPLIES 7
Nathaniel_C
Super User
Super User

Hi @aartiladdha ,

It works for me. PBIX 
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

plant.PNG





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Washivale
Resolver V
Resolver V

Hi @aartiladdha ,

 

Create measures as below to understand outcome behaviour on slicer selection

 

Measure1 = Sum(Table[Capacity])

Measure2 = Calculate(Measure1, ALL(Table[Plant Group]))

Measure3 = Calculate(Measure1, ALLSELECTED(Table[Plant Group]))

 

let me know if it helps,

 

Regards,

Washivale

 

 

Nathaniel_C
Super User
Super User

Hi @aartiladdha ,

Create a measure = SUM(table[Capacity]) and drop it on a Card. Select the [Plant Group ]as Slicer.
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




I was pulling the Plant group from another table. It looks like a relationship issue. Once I changed it from single to "Both", it showed me correct result. Working fine now but I do want to understand how does this relationship work? Any idea?

Hi @aartiladdha ,

 

Glad you were able to figure it out. for understanding how relationships work, below would be a good starting point.

 

https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships

 

Regards,

Washivale

 

 

This is giving me sum of all the plant groups i.e. 78k

HI @aartiladdha ,

 

All three Measures Resulting into 78k? Try selecting/deselectiong plant groups to check end output for all three measures.

 

Regards,

Washivale

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.