Forum Discussion

WBscooby's avatar
WBscooby
Icon for Helper III rankHelper III
5 years ago

Using filters in measures/ Applying to a visual

Hi   I am getting in a mess with filters again and would appreciate some guidance. I have created a simple replica of my file as my data is quite sensitive.   Essentially I have 2 key tables - Sa...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi  WBscooby ,

I put RepeatCustomer (groups) into SalesTransactions using the Related function

RepeatCustomer (groups) = RELATED('Sales'[RepeatCustomer (groups)])

Through counting, it is found that in Q1 18/19, when Outcome Level is High,If RepeatCustomer (groups)=Yes, 4, if RepeatCustomer (groups)=No, 8

Your result did not seem wrong, you say there should be two repeat customers and eight non-repeat customers, it refers to the circumstances under which

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

WBscooby's avatar
WBscooby
Icon for Helper III rankHelper III
5 years ago

Hi Liu Yang

 

Thank you for replying. From the Sales table, there are 10 customers in Q1 1819. Of these, 4 are repeat customers. If you filter the sales transactions to Outcome level = high in the Sales Transactions table, only 2 will qualify as repeat customers as the Outcome level = low is not counted as a repeat. As there are 10 customers in Q1 1819 that means 2 repeat, 8 non repeat. I'm unsure how to show this as I would like the user to be able to use a slicer to determine if repeat customers include high or low level outcomes. Hope that makes sense!

 

Thank you

Jess