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
Vote for your favorite t-shirt design now through March 28.
Find out more about the March 2023 update.
Find out more about the online and in person events happening in March!