The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi all,
May know the best way to sum the total value in visual so that I can get the percentage under total visual as per below.
Yield in M2 (%) = Total GR (M2) / Total GI (M2)
Regards,
Nuha
Solved! Go to Solution.
hi @Anonymous
try using the below measure
Yield in M2 (%) = Sum(Table[Total GR (M2)]) / Sum(Table[Total GI (M2)])
If this post helps , accept it as a solution
hi @Anonymous
try using the below measure
Yield in M2 (%) = Sum(Table[Total GR (M2)]) / Sum(Table[Total GI (M2)])
If this post helps , accept it as a solution
Thanks! I create a "new measure" and do division.