Forum Discussion

ppgandhi11's avatar
ppgandhi11
Helper 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.

     

     

     

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

Well, if TotalSale is a measure, then you should just need to create another measure like this:

 

Classification = IF([TotalSale]>=30000,"High Sale", "Low Sale")

I might be missing something.