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.

     

     

     

     

Anonymous's avatar
Anonymous
Not applicable
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.

 

 

 

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Can this be achieved as a column in the original table? is there a way to achieve the grouping and bucketing in a single step?