Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

BIN Range / Dynamic Segmentation based on measure

I have StoreId's and their sales(column name = RetailDollars). I have created a measure for totalsales -  Totalsales$ = SUM(SellThrough[RetailDollars])  I have created a BIN           T...
Need Help
Show and Tell
  • v-yuta-msft's avatar
    v-yuta-msft
    6 years ago

    Anonymous ,

     

    You can simply create a calculate column in the sales table using dax as below:

    Number of stores = CALCULATE(COUNT('Table'[StoreID]), FILTER('Table', 'Table'[Sales] >= Bin[Min_Value] && 'Table'[Sales] <= Bin[Max_Value]))

     

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.