Dual Dynamic Segmentation

[jsm2116]

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 <5 , 6-10, 11+. And then by a distinct count of vendors.  An output example is below. All of my attempts aggragates both values  with a result  10 Vendor Count and Bucket = 11+. Any guidance would be appreciated. Thank you.

Vendor Count      Bucket 

         5                    <5                     

         3                  6-10 

         2                  11+ 

[Anonymous]

Hi @jsm2116 ,

Not very clear... Are you confused about why there is only one reord ? 

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.

Please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

Best Regards,
Eyelyn Qin

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

[parry2k]

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