Forum Discussion

LyonsBI_BRL's avatar
LyonsBI_BRL
Icon for Helper III rankHelper III
5 years ago
Solved

Calculate Percentage by SKU category

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 per...
Need Help
  • LyonsBI_BRL's avatar
    LyonsBI_BRL
    5 years ago

    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)
Anonymous's avatar
Anonymous
Not applicable
5 years ago

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's avatar
    LyonsBI_BRL
    Icon for Helper III rankHelper III
    5 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      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.