Dynamic table with agregaregated datas - venn diagam

[Lokisame]

Hello, 

is it posible to create table or measue(with table inside) that will be depending on the current page filters?

I have a table containing information whether a given customer bought a given product in a given month:

CustomerID	Product1	Product2	Month
1	1	1	January
2	1	1	January
3	0	1	January
1	0	0	February
2	1	0	February
3	1	0	February
1	1	1	March
2	1	0	March
3	1	1	March

I need to create table with information about whether a given customer bought a given product in the selected time range.
For example:
Customer 2 bought only product 2 in Jenuary, but he by product 1 and product 2 when we look at whole quarter.
The time range should depend on the filter on the page. 

I need this table, or rather its columns to create ddynamic venn diagram.

I tried to do it using DISTINCTCOUNT but the given customer fell into both the basket in which he bought one product and the basket where he bought two products at the same time during the quarter filtering.

[v-cherch-msft]

Hi @Lokisame 

It seems you may use slicer as below.If it is not your case,please explain more about your expected output.

Regards,

[Lokisame]

In your case from your table (just for customer 1):

When we filter Jan: on chart we should see 1:0:0 - beacause customer 1 bought only "product 1" in this month
When we filter Feb: on chart we should see 0:1:0 -beacause customer 1 bought "product 1" and "product 2" in this month

But when we dont use any filters soo we look at jan, frb, mar we should see 0:1:0 - coz customer 1 bought "product 1" and "product 2" in this quarter - no metter how many times

[v-cherch-msft · Accepted solution]

Hi @Lokisame 

You may change the aggregation to Count instead of Count(distinct).Then it could count the times.

Regards,