Forum Discussion
Matrix table
I would like to transform my table as follow: Can anyone her helps me to solve this problem? Thank you in advanced!
Do you actually need this as a physical table in your model? If you need to see it as a visual, all you need is to create a measure using COUNT for the discount field and create a matrix with the customers as rows, the discount field as columns and the measure as values. So...
Count Discount =
COUNT(fTable[Discount])