Could you please help me with filtering:
I have theese measures: Country; Producer; Category; SubCategory; Month.
I have calculated Market Share of Producers, where I take for base 1Month and all brands.
Can you give us an example where we can see the wrong result and what is the expected right result?
Also if you share your pbix file would be nice.
@Anonymous Try that one and tell me if it works.
SHARE% = CALCULATE(SUM(DB[VOLUME]); FILTER(db;DB[MONTH]=DB[MONTH])) /CALCULATE(SUM(DB[VOLUME]);ALL(DB[MONTH]);ALL(DB[PRODUCER]);ALL(DB[CATEGORY]);ALL(DB[SubcATEGORY]))
this formula works great, if we want to see the share from the full data base - I will save this formula, thank you.
But in my example full data base (100%) changes after choosing filters, for example, I choose bar and cone categories or just cone category - in all theese cases it changes base.
Maybe you have another Ideas?
mmmm...give me more details or draw me something with the expected result ....for example if we filter by cone...what do you expect to have as a result
Lets take volume of December. I choose Cone (261kg) and Bar (17.5kg) categories - sum is 279kg. So the share of O1 is 44% (123.9/279=0.44) etc.
In your formula it takes full sales of all producers in december (1777kg) - the share of cone and bar categories is 6.9% (123.9kg/1777kg).
In mu current verision it takes only 261kg for cone and bar categories, because top 4 producers do not sell bar ice cream.
Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.
Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!
We had a great 2022 with a ton of feature releases to help you drive a data culture.