I have this following situation where I want to calculate = Sum of (product sale by group)/Sum of Total product in Group
From this data, desired output is: = (599/2332) = 0.25
Thanks in Advance
Go to Solution.
This will give you the result you say you want, regardless of what/where you filter. Not sure if that is what you are after though
New Measure = DIVIDE(
SUM(Table1[Product sale by Group]),
SUM(Table1[Total product in group]),
Proud to be a Datanaut!
View solution in original post
Hi @aktripathi2506,As the @Phil_Seamark posted, create a measure using the formula and create a card to display the expected result as follows.If you have resolved your issue, please mark the right reply as answer, if it doesn't, please feel free to ask.Best Regards,Angelia
Not sure if I got you right. The formula of your measure would be:
SUM(product sale by group),
SUM(Total product in Group),
Hope this helps
Click here to read more about the December 2021 Updates!
Mark your calendars and join us for our next Power BI Dev Camp!
Learn how to create your own user groups today!