Need % for each subcategory with category with respect to total purchased subcategory.

[mg01]

Hi Team,

Below is screenshot for data output the same output I need to replicate in Power BI matrix:

I need to calculate the last % value, For Ex. For ALL ITEMS Category, we have Branch Stocked Subcategory 
The Unique Items value is 524
And Total Purchased Subcategory within ALL ITEMS Category the Unique Item value is 1328
% value of Branch Stocked = 524/1328=39.5%, Same type of calculation we need for all subcategory within a category.

Power BI Screenshot:

 What measure I need to create to get similar output in Power BI?

Thanks in advance!

[Mahesh0016]

@mg01 

% value of Branch Stocked =

VAR Sub_ListPrice = CALCULATE(MAXX(ALLSELECTED(TrainingSample2[Business Segment]),[Total ListPrice]))

RETURN

DIVIDE([Total ListPrice],[Sub_ListPrice],0)

#Sub_ListPrice

Sub_ListPrice = CALCULATE(MAXX(ALLSELECTED(TrainingSample2[Business Segment]),[Total ListPrice]))

@mg01 If this post helps, please consider accept as solution to help other members find it more quickly and Appreciate your Kudos.

[mg01]

I tried first this measure :

sub1 category = CALCULATE(MAXX(ALLSELECTED('Total Purchased'[Sub Category]),COUNT('Total Purchased'[Column])))

where
Unique Items= COUNT('Total Purchased'[Column])

But not getting correct result.