Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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. 

quantumudit
Kudo Collector
Kudo Collector

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)?

quantumudit
Kudo Collector
Kudo Collector

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors