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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
CJANE
Helper I
Helper I

Need to show total value on row if greater than x

Need help creating a measure so I can show total sum of account where individual holdings exceed X.  In the example below I need to calculate % over 12%.  I have the underlying data for Account, Secuirty, % of Account.

 

AccountSecurity% of Account% over 12%
1a558
1b1058
1c1058
1d858
1e2358
1f3558
1g1058
2h3564
2i1564
2j1464
2k1264
2l1264
2m1264
3n30100
3o20100
3p20100
3q20100
3r20100
2 ACCEPTED SOLUTIONS
parry2k
Super User
Super User

@CJANE "% of Account" is this a column in your table or it is a measure? 

 



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

View solution in original post

CJANE
Helper I
Helper I

Thank you this was very helpful.

View solution in original post

4 REPLIES 4
CJANE
Helper I
Helper I

Thank you this was very helpful.

parry2k
Super User
Super User

@CJANE you can add a new calculated column like this:

 

Column = CALCULATE  ( SUM ( TableX[% of Account] ), FILTER (  ALLEXCEPT ( TableX, TableX[Account] ),  TableX[% of Account] > 12 ) )

 

 



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

CJANE
Helper I
Helper I

% of Account is a column in the table

 

parry2k
Super User
Super User

@CJANE "% of Account" is this a column in your table or it is a measure? 

 



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.