Hi All,
I'm trying to find a solution for the "Which Segment Buys more?" Lesson of the PowerPivot training.
I took a different approach an created a Calculated Column in the Customer table:
= IF( AND([Kids] = "Yes" , [Marital Status] <> "Married") , "Yes" , "No")
Then I create a simple "Sum" measure:
SUM(fctSales[SaleAmount])
and I get the correct result. The measure is correctly filtered by the "context filters".
The problem is when I try to find the number of single parents in each location. I created this measure
=DISTINCTCOUNT(Customers[Cust ID])
This gives the correct number at the gender level, but ignores the row context of the city.
I'm not sure why one works and the other one work "partially".
Regards,
Fernando
I'm trying to find a solution for the "Which Segment Buys more?" Lesson of the PowerPivot training.
I took a different approach an created a Calculated Column in the Customer table:
= IF( AND([Kids] = "Yes" , [Marital Status] <> "Married") , "Yes" , "No")
Then I create a simple "Sum" measure:
SUM(fctSales[SaleAmount])
and I get the correct result. The measure is correctly filtered by the "context filters".
The problem is when I try to find the number of single parents in each location. I created this measure
=DISTINCTCOUNT(Customers[Cust ID])
This gives the correct number at the gender level, but ignores the row context of the city.
I'm not sure why one works and the other one work "partially".
Regards,
Fernando