topic Re: Counting columns and group by another column in a joined table in DAX Commands and Tips

Counting columns and group by another column in a joined table

wkolcz — Tue, 30 Mar 2021 19:12:28 GMT

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)

Re: Counting columns and group by another column in a joined table

quantumudit — Tue, 30 Mar 2021 19:20:09 GMT

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

Re: Counting columns and group by another column in a joined table

wkolcz — Tue, 30 Mar 2021 19:42:29 GMT

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

Re: Counting columns and group by another column in a joined table

quantumudit — Sun, 04 Apr 2021 04:54:01 GMT

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

Re: Counting columns and group by another column in a joined table

rfigtree — Sun, 04 Apr 2021 06:23:12 GMT

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.