Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Experts,
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.
Thank you,
Re
Solved! Go to Solution.
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
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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |