Count Product sub category group by Monthwise

[kritpatel]

Hello Experts,

Need some advise on how to calculate product subcategory fall in every month.

for e.g -Fter(Category 2) is unique for ED-4,(Category 1) which comes manytime in month in Sales table stored by Category 3 & 4.

Here i wanted Category 2 - fall under month (it should be count as 1 if in Jan'18 there are 5 no of sales transaction issued by category 3/4) & for Feb 1,

so output

Month - Category 2

Jan'18 - 2 Fter

Jan'18 - 1 Ster

Feb'18 - 4 Fter

Feb'18 - 2 Ster

Category I	Category II	Country	Customer	Category III	Category IV	Month	Revenue
ED-4	Fter	Nigeria	V1	Packages - Others	1001	Jan-18	65
WE	Fter	Angola	EM1	Packages - Others	1001	Jan-18	72
Base	Shef	Congo	PCO	Packages - Others	1002	Jan-18	150
ED-4	Fter	Nigeria	V1	Packages - Others	1004	Feb-18	182
WE	Fter	Angola	EM1	Packages - Others	1001	Jan-18	182
MV	Fter	Ghana	E1	STE	1006	Jan-18	240
MV	Fter	Ghana	E1	Packages - Others	1009	Jan-18	300
WC	Fter	Gabon	OP	Packages - Others	1005	Jan-18	300
Base	Shef	Congo	PCO	Packages - Others	1004	Jan-18	350
U22	Shef	Congo	E1	Packages - Others	1101	Feb-18	360
D12	Fter	Senegal	KE	Packages - Others	1006	Jan-18	365
U22	Shef	Congo	E1	Packages - Others	1006	Jan-18	390

[v-cherch-msft]

Hi @kritpatel

It's not clear about your sample and expected output. It caused me confused. Here are some references for you.

https://community.powerbi.com/t5/Desktop/Sum-of-distinct-counts-over-filtered-months/td-p/319378

https://www.daxpatterns.com/budget-patterns/

Regards,

Cherie