I'm trying to calculate the R3M Percentage of Total but somehow is not working. I was able to calculate the monthly percentage of total for the below example:
|Period||Product||Monthly Sales||Total Sales Per Period||Market Share|
Now, what I want to achieve is the same but for R3M, so far I was able to calculate the R3M Sales with the following measure:
Sales R3M = Calculate ( sum ( 'fact table'[sales]), datesinperiod ('dim calendar'[date], lastdate('dim calendar'[date]), -3 , month)) but I'm not sure how to calculate Total R3M Sales per Period and R3M Market Share. So for an example, please see below. I don't know how to calculate the last two columns of the below table:
|Period||Product||Monthly Sales||Sales R3M||Total R3M Sales Per Period||R3M Market Share|
|201801||Apples||10||10||= 10 + 4 + 1||=10/ Total R3M Sales per Period|
I've tried using SUM(Sales R3M), but it doesn't work because [Sales R3M] is a measure and not a column.
Any help will be highly appreciated and please let me know if you need further details.
Thank you so much!
Solved! Go to Solution.
Omg, thank you so much Ashish, it worked brilliantly!!
I had some products filter out, so I change the ALL for ALLSelected and it worked! 😄
Again, thank you very much!!
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.