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.
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