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!!
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.