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

Why not just using a slicer chart to achieve this?

 

 

 

ppgandhi111's avatar
ppgandhi111
Helper I
8 years ago

How would this work Jessica? The High Sale and Low Sale are not connected with the Product table anyhow. The post I had shows that they are coming from the measure called "Group".  

 

Can you please elaborate?