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)
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

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