Hi @philthegaps ,
My original data table is the following table.
Select the colour column, then select the pivot column, in the message box, select Fruits for the Values column and "count all" for the advanced options.
Then you will get the result:
At this point, you get a colour-based count.
If I have misunderstood you, you can share the pbix file that wipes out sensitive information and the expected results.
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Yes I think you misunderstood me. I don't want a solution with M or DAX, but a "direct" solution with the Table/Matrix visual.
But I think there is no alternative so far, I have to use Dax or M.
@philthegaps not sure why you want to do this and what is the rational behind this. If you don't want to create a column or measure (you should write measure), in this case, you need to pre-aggregate in Power Query and then just visualize it.
Click here to read more about the November 2022 updates!
Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.
This session walks through creating a new Azure AD B2C tenant and configuring it with user flows and custom policies.