Forum Discussion

ppgandhi11's avatar
ppgandhi11
Icon for Helper V rankHelper V
8 years ago
Solved

dynamic grouping question.

Hi, I am very new to power bi, i think the task i am undertaking is too big. Here is what I want to do. I need some good start point.   I have a table with 2 columns. Products and sales. 1:many rel...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hmmm, I may misunderstanding your case since I don't know your data structure. My suggestion is provided based on the following scenario.

     

    There is a Product -> sales table like this. One product could have several sales value.

     

     

    Then created a new table using the following Dax

     

    Total Sales = GROUPBY('Product','Product'[Product],"Total Sales",SUMX(CURRENTGROUP(),'Product'[Sales]))

    And then, created a new column to tag the product based on the total sales number

     

    Sales Range = IF([Total Sales]<30000, "Low Sales", "High Sales")

     

     

    After that, you could create a chart to show the High/Low Sales products.

     

     

     

     

ppgandhi11's avatar
ppgandhi11
Icon for Helper V rankHelper V
8 years ago

Perfect! This is what I was looking for! Thanks bunches Jessica. Learnt about CurrentGroup() today. didn't know how to use that. :)

v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
8 years ago

ppgandhi11,

 

Glad to hear that. You may help accept solution. Your contribution is highly appreciated.