Calculate Percentage by SKU category

[LyonsBI_BRL]

I'm needing some help to calculate the over all percentage of each SKU. 

So this way I can create a card one showing the total number of times the customer has selected that SKU, as well as what percentage is it of all of the SKUs that are available. 

Any help would be greatly appreciated

[Anonymous]

HI @LyonsBI_BRL .

Follow the below mentioned steps in order to get the desired output;

1)Create a measure as TotalCount=COUNT(Table(SKU)).

2)EveryCount=CALCULATE([TotalCount],ALL(Table(SKUCategory)).

3)%ofTotal=DIVIDE([TotalCount],[EveryCount],0).

Regards,

Sanket Bhagwat.

[LyonsBI_BRL]

@Anonymous is there a way to exclude rows? Basically I have several rows that return NO SKU Selected, can I exclude those?

[Anonymous]

If there are less rows and you can identify which rows have no SKU, then you can filter out those rows in the filter pane.

[amitchandak]

@LyonsBI_BRL , Based on what I got, You can right click on measure and use % of total in visualization.

Or create a measure 

divide(count(Table[SKU]), calculate(count(Table[SKU]), allselected(Table)))

[LyonsBI_BRL · Accepted solution]

Figured it out thank you all though!! 🙂

Percent of SKU1 =

VAR SKU =

Sum('Grouped MainLOE'[SKURequested1])

VAR SKUAll =

SUMX(

ALL('Grouped MainLOE'),

'Grouped MainLOE'[SKURequested1]

)

Return

DIVIDE(SKU,SKUAll)