This is my Table
Below is the measure for AUM Introducer Count 1, but I dont know how to create measure for AUM Band %_1.
Anyone Please help.
Go to Solution.
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
Hope this helps 🙂
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
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.