Count

[M_SBS_6]

Hi, 

I have a table that output like this 

Brand.  Cust

ARC.   10

BT.      10

Mc.     10

RY.       8

WHS.   6

However, I'd like to see the matrix look like this where by "cust" becomes a Column and the Volume underneath is the sum of the "brand".

10.     8.    6

3.       1.    1

Is this possible please? 

[Ritaf1983 · Accepted solution]

Hi @M_SBS_6 
You can use a matrix visual with cust on rows and counting the brands on values.

pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other

members find it more quickly

[amitchandak]

@M_SBS_6 , You have to segmentation for that using independent table created using generateseries 

Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ

Customer Retention with Dynamic Segmentation, New/Lost/Retain Customer Count: https://youtu.be/EyL7KMw877Q