How to create Measure to find % on total week sales per group divide by Total sales for the group

[Khathu_King]

Good day 

I am new on power BI  

someone  Please help me on How to create Measure to find % on total week sales per group divide by Total sales for the group,

see Attached Photo the value i would like to calculate is % of sales per Supplier Category which eg Sales per Supplier Category Divide by Total Sales excell file

[amitchandak · Accepted solution]

@Khathu_King ,a new measure assume you have sales measure

% Sales = divide([sales], calculate([sales], removefilters(Table[Supplier])))

or

% Sales = divide([sales], calculate([sales], filter(allselected(Table) ,Table[Week] max(Table[Week])) ))

[Khathu_King · Accepted solution]

100% Thanks a lot @amitchandak 

[amitchandak · Accepted solution]

@Khathu_King ,a new measure assume you have sales measure

% Sales = divide([sales], calculate([sales], removefilters(Table[Supplier])))

or

% Sales = divide([sales], calculate([sales], filter(allselected(Table) ,Table[Week] max(Table[Week])) ))