Hi,
I'm new to power pivots and dax formulas.
Does anyone know how I can work out the average value of distinct count based on a criteria?
Let's assume I have the tables below
Customer Table
Customer - Region
a - AA
b - AA
c - BB
d - CC
Product Table
Product - Type
1 - X
2 - X
3 - Y
4 - Z
Sales Table
Time - Product - Customer
Day 1 - 1 - a
Day 1 - 2 - a
Day 1 - 3 - a
Day 1 - 1 - b
Day 1 - 2 - c
On any given day (which I can use a power pivot filter for) how do I create a DAX formula that tells me region AA saw 3 unique product types purchased?
Hoping this is easy enough for the experts.
Thanks
I'm new to power pivots and dax formulas.
Does anyone know how I can work out the average value of distinct count based on a criteria?
Let's assume I have the tables below
Customer Table
Customer - Region
a - AA
b - AA
c - BB
d - CC
Product Table
Product - Type
1 - X
2 - X
3 - Y
4 - Z
Sales Table
Time - Product - Customer
Day 1 - 1 - a
Day 1 - 2 - a
Day 1 - 3 - a
Day 1 - 1 - b
Day 1 - 2 - c
On any given day (which I can use a power pivot filter for) how do I create a DAX formula that tells me region AA saw 3 unique product types purchased?
Hoping this is easy enough for the experts.
Thanks