Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
Hi @Lokisame
You may change the aggregation to Count instead of Count(distinct).Then it could count the times.
Regards,
Hi @Lokisame
It seems you may use slicer as below.If it is not your case,please explain more about your expected output.
Regards,
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
Hi @Lokisame
You may change the aggregation to Count instead of Count(distinct).Then it could count the times.
Regards,