Thanks for the tutorial, just one question is it possible to have a matrix that has the Segment and a subrow with the customer that belong to that segment? Something like this: Segment 1 3000 Customer Customerkey11002 CustomerKey11010 Segment 2 1500 Customers CustomerKey11346
Hello hope you could help me on this one: I have a very simple long and thin fact table (with 3 columns: date, text descriptor and corresponding numerical values). I just want to filter data (for example: descriptor 1 with corresponding values) against range of another data (descriptor 2 and corresponding values). In clear I want the values of my descriptor 1 when values of descriptor 2 is in a specific range (10-20, 20-30, …, 90-100). I am stuck since one month… Each descriptor comes from different source tables where everything was in a lot of columns (headers: date, descriptor 1, descriptor 2, …, descriptor 350. The cells below are all numerical values). I had to unpivot other columns than the date to be able to use it in the data model. I also have a lookup table that categorizes and sub-categorizes the descriptors and also min and max targets for each descriptor. How can I do that please?
Hi Reza, This is great. Thank you very much I am struggling to get the analytics for Sub-segment. In my case, I have some customers who have ordered 2000 times. So I want to segment the Number of customer order into range like "1-100 orders", "100-200 orders" and so on. However, I am unable to do it. I added a calculated column to our segment table and tried to bring in the count of customers with that number of order (in your example) but the value is blank. I do I relate the count of customer with x number of order to an order range? Thanks in advance
Hey, we were struggling to get the customer segmentation done and I found your video to be the most useful among all on youtube. However, just wondering, how do we handle number of visits more than the max value in segment? As i we don't include those users, the data won't be correct. For example, if max in segment is 8, what if some visited more than 8 time. Can we do some logic to define that even if they visited more than 8, it is still shown in 8? If you can help us resolve this.. we will be grateful
Use the following to dynamically increase your Index in the segment table. SegmentTable= Var VirtualTransactionforCustomer = SUMMARIZE(Sales Table','Sales Table'[CustomerID], "No of Transaction", [Total Transaction]) Var DynamicIndex= GENERATESERIES(0,MAXX(VirtualTransactionforCustomer, [No of Transactions]),1) Return DynamicIndex Note: Total Transaction = Countrows(Sales Table)
Thank you very much for all the awesome articles. This one particularly is what i spent days to wrap my head around. I have excel background and relatively new to Power BI anyways. Your content is helping me understand a great deal about the logic of DAX. For the above segmentation, what would be the change if we need to segment the same info further within groups of 'hours of purchase'? and be able to filter them for any month as well using a slicer?
Awesome Reza that commendable very very nice explanation
Thanks for the tutorial, just one question is it possible to have a matrix that has the Segment and a subrow with the customer that belong to that segment?
Something like this:
Segment 1 3000 Customer
Customerkey11002
CustomerKey11010
Segment 2 1500 Customers
CustomerKey11346
Hello hope you could help me on this one: I have a very simple long and thin fact table (with 3 columns: date, text descriptor and corresponding numerical values). I just want to filter data (for example: descriptor 1 with corresponding values) against range of another data (descriptor 2 and corresponding values). In clear I want the values of my descriptor 1 when values of descriptor 2 is in a specific range (10-20, 20-30, …, 90-100). I am stuck since one month…
Each descriptor comes from different source tables where everything was in a lot of columns (headers: date, descriptor 1, descriptor 2, …, descriptor 350. The cells below are all numerical values). I had to unpivot other columns than the date to be able to use it in the data model.
I also have a lookup table that categorizes and sub-categorizes the descriptors and also min and max targets for each descriptor.
How can I do that please?
lovely content
When I try to create the aggregate table through measure it gives me a error - Multiple columns cannot be converted to a scalar value.
Thanks so much Reza. I am struggling with this issue. How do I include the costumers with more than 8 orders in the parameter?
Hi Reza,
This is great. Thank you very much
I am struggling to get the analytics for Sub-segment. In my case, I have some customers who have ordered 2000 times. So I want to segment the Number of customer order into range like "1-100 orders", "100-200 orders" and so on. However, I am unable to do it. I added a calculated column to our segment table and tried to bring in the count of customers with that number of order (in your example) but the value is blank.
I do I relate the count of customer with x number of order to an order range?
Thanks in advance
Great explanation Reza 🙂
Hey, we were struggling to get the customer segmentation done and I found your video to be the most useful among all on youtube. However, just wondering, how do we handle number of visits more than the max value in segment? As i we don't include those users, the data won't be correct.
For example, if max in segment is 8, what if some visited more than 8 time. Can we do some logic to define that even if they visited more than 8, it is still shown in 8?
If you can help us resolve this.. we will be grateful
Use the following to dynamically increase your Index in the segment table.
SegmentTable=
Var VirtualTransactionforCustomer =
SUMMARIZE(Sales Table','Sales Table'[CustomerID], "No of Transaction", [Total Transaction])
Var DynamicIndex= GENERATESERIES(0,MAXX(VirtualTransactionforCustomer, [No of Transactions]),1)
Return
DynamicIndex
Note: Total Transaction = Countrows(Sales Table)
Thank you very much for all the awesome articles. This one particularly is what i spent days to wrap my head around. I have excel background and relatively new to Power BI anyways. Your content is helping me understand a great deal about the logic of DAX.
For the above segmentation, what would be the change if we need to segment the same info further within groups of 'hours of purchase'? and be able to filter them for any month as well using a slicer?
👍