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 learn more about the September 2022 updates!
Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.
Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!