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
Anonymous
Not applicable

Divide % Calculation

Hi Experts,

This is my Table

 ALL2.PNG

Below is the  measure for  AUM Introducer Count 1, but I dont know how to create  measure for AUM Band %_1. 

Anyone Please help.

ALL1.PNG

 

Thank you,

 

Re

1 ACCEPTED SOLUTION
TheoC
Super User
Super User

Hi @Anonymous 

 

You can create Calculated Column as per below or replicate using measures.

 

% = 

VAR _SumAum = SUM ( 'Table (2)'[AUM Introducer Count_1] )
VAR _SumAumGroup = CALCULATE ( SUMX ( 'Table (2)' , 'Table (2)'[AUM Introducer Count_1] ) , ALL ( 'Table' ) )

RETURN

_SumAumGroup / _SumAum

 

TheoC_1-1634538213510.png

 

Hope this helps 🙂

 

Theo 

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

View solution in original post

1 REPLY 1
TheoC
Super User
Super User

Hi @Anonymous 

 

You can create Calculated Column as per below or replicate using measures.

 

% = 

VAR _SumAum = SUM ( 'Table (2)'[AUM Introducer Count_1] )
VAR _SumAumGroup = CALCULATE ( SUMX ( 'Table (2)' , 'Table (2)'[AUM Introducer Count_1] ) , ALL ( 'Table' ) )

RETURN

_SumAumGroup / _SumAum

 

TheoC_1-1634538213510.png

 

Hope this helps 🙂

 

Theo 

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

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.