Dual Dynamic Segmentation

Question

I am tasked to create a table utilizing a dual Dynamic. One measure that will count each occurance with the time span selected and bucket by count &lt;5 , 6-10, 11+. And then by a distinct count of vendors.&nbsp; An output example is below. All of my attempts aggragates both values&nbsp; with a result&nbsp; 10 Vendor Count and Bucket = 11+. Any guidance would be appreciated. Thank you.&nbsp;Vendor Count&nbsp; &nbsp; &nbsp; Bucket&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 6-10&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 11+&nbsp;

parry2k · Answer

jsm2116&nbsp;I just recently did a similar thing for one of my customers and in the coming days will be writing a blog post on it and will let you know when it is ready so that you can implement the same solution.

anonymous · Answer

Hi&nbsp;jsm2116&nbsp;,&nbsp;Not very clear...&nbsp;Are you confused about why there is only one reord ?&nbsp;&nbsp;Measure returns a single value, so if you want to display all values based on each row, you should add a original field to Table visual along with the measure. Or you could create a calculated column instead.&nbsp;Please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.&nbsp;Best Regards,Eyelyn QinIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Dual Dynamic Segmentation

2 Replies

Related content

Dynamic Segmentation

|| Dynamic Segmentation : The formula ||

Dual Storage mode

Dynamic Customer Segmentation

filter with segmentation