Occasional Visitor
Posts: 1
Registered: Friday

How to group data on table



How do I display Product Categories and Product Count Against each category in a tabular format?


Just like writing


SELECT c.Name AS Category, Count(p.ID) AS ProductCount

FROM Category c

INNER JOIN Product p ON c.ID = p.CategoryID



And is it possible to even write SQL Queries in PowerBI? I use to do this in QlikView!



Regular Visitor
Posts: 29
Registered: ‎03-30-2016

Re: How to group data on table

You should be able to add Category and ID to a table visualization.  On the ID click the little down arrow and select "Count" (Values section of the table element on the right side menu).


I'm not familiar with QlikView.  You can use SQL to get your data into Power BI from a source that supports it, but DAX is used to create measures and calculated columns within the model.