Forum Discussion
Dynamic Customer Grouping
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
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.
wdx223_Daniel Amazingg. This workss!!
Any idea on how we can achieve part 2 I mentioned?
Like finding the exact company pairs with respect to number of customers?
For ex:
number of customers that buy from company 1 and company 2?
number of customers that buy from company 1 and company 2 and company 3?
And all possible combinations?
spacerocket22 might this work, draw company_key in a list slicer, then you can assign your combination.
I wish to list the company names as combinations as well.
Any ideas?
Something like this:can create a dimension table like this. it is a hard work