Solved: DAX to caculate % of total brand

locle90 · ‎12-20-2020

Dear All,

I have the file with revenue 12month with 3 brand.Could you help to write the DAX with this request ?

When i select the month. Then the DAX can show 3 brand with % ( revenue brand/total revenue by month)

Thanks

AllisonKennedy · ‎12-21-2020

@locle90 You can create a new MEASURE:

BrandMarketShare = DIVIDE(SUM(Table[Revenue]), CALCULATE(SUM(Table[Revenue]), ALL()))

Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

AllisonKennedy · ‎12-21-2020

@locle90 You can create a new MEASURE:

BrandMarketShare = DIVIDE(SUM(Table[Revenue]), CALCULATE(SUM(Table[Revenue]), ALL()))

Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

locle90 · ‎12-21-2020

Hi,

And i want to add 1 collum for YTD with revenue.Coud you help me again ?

DAX to caculate % of total brand