cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
wkolcz
Frequent Visitor

Counting columns and group by another column in a joined table

I have two spreadsheeting I imported into data. In the model I joined the two datasources on a column (sku). I need to count the values in column (click-throughs) in table 'Clicks' and group it by 'brandName' and in Product table to product a measure that includes the brandName and the total clicks (based on skus in that family)

 

clicks.PNG

4 REPLIES 4
rfigtree
Resolver III
Resolver III

Assume you have brand/product table linked to the click table on sku. Measure=sum([clicks])

Created pivot table with

 Brand and product as the label columns and measure as the value column. 

Quantum_Udit
Advocate V
Advocate V

Hey @wkolcz 

Sorry for the late reply.

It would be great if you could send me a sample file with a detailed explanation of what output you want, so that, I can try to help you out.

 

Thanks,

Udit

wkolcz
Frequent Visitor

Thank you. How do I group by a column on table 2 (Product) when I join the sku across them and count the click-throughs from table 1 (Clicks)?

Quantum_Udit
Advocate V
Advocate V

Hey @wkolcz 

 

You can group values in two ways, i.e.,

1. Power Query: By using the 'Group By' functionality

2. DAX: Creating a virtual table by using the SUMMARIZE() function 

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates