Forum Discussion
Pivot Table in Power BI and Counting
Hello All,
This is the screeshot of a data and data model
I am newbie to the Power BI and I am in process of making a report as shown in the below. The table below shows following information
- The sales rep of Auburn Mart is Trisha and has all three product of brand Mahi.
- The sales rep of Merryland Mart is Trisha and has all three product of brand Mahi.
- The sales rep of Parramatta Mart is Trisha and they have just 1 product (A) of brand Mahi
- The Sales rep of Lidcome Mart is Kobi and he has 2 products of brand Mahi(A&C).
- The sales rep of Clyde Mart is Kobi and he has 1 product A and 1 product C
- The Sales rep of Granville Mart is Merry and she hasjust 1 product A.
I am able to do this in Excel via Pivot Table but not is Power BI. I want to have table and function like this in Power BI
The above pivot table shows the same. The table below the Pivot tables summarize the pivot table. It shows that Trisha has 3 stores (001,002,003) and out of these store, 2 of them (001 and 002) has atleast 2 products. Similarly, Kobi has 2 store and both of them has atleast 2 products. In contrast Merry has just 1 store and none of them has atleast 2 products.
Pls do help me to get the table like the Pivot Table in and the summary field like above in Power BI
1 Reply
- lbendlinSuper User
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523