Forum Discussion

spacerocket22's avatar
spacerocket22
Frequent Visitor
5 years ago
Solved

Dynamic Customer Grouping

I work for an organization that owns 15 companies. 1. I want to show the number of customers that purchased from 1 company, 2 companies, 3 companies, etc. 2. I also want to know the number of custo...
  • amitchandak's avatar
    amitchandak
    5 years ago

    spacerocket22 , You have to create a measure

    count(Table[company_key]), As a measure, this can not be used as a filter. You need to create an independent table manually or using generateseries with 1 to 100(say). And create new measure/s that uses this table.

    Refer to my dynamic segementation video. You case = join will work no need of range unless you need a range

    https://www.youtube.com/watch?v=CuczXPj0N-k

  • wdx223_Daniel's avatar
    wdx223_Daniel
    5 years ago

    spacerocket22  please try this step by step

    Step 1: create a date table

    Step 2: create a dimension table

     

    Step 3: create relationship between Dates[Date] and FactTable[date_key]. of cause, you need convert your data in column of date_key to Date Type.

     

    Step 4: create a measure

    Step 5: draw the column and measure into a tabulor visual, and date to slicer

     

    that's all.