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 ,

Here are the steps you can follow：

1. Create calculated column.

 

RepeatCustomer1 =
IF([Outcome Level]="High",[RepeatHigh],[RepeatLow])

 

2. Create measure.

 

distinct = DISTINCTCOUNT('SalesTransactions'[Link ID])

 

3. Use the [Cohort] column and [Outcome Level] column of the SalesTransactions table as slicers. Place measure[distinct] and calculated column[RepeatCustomer1] into the Pie chart

4. Result.

When Cohort is Q1 18/19 and Outcome Level is High

When Cohort is Q2 18/19 and Outcome Level is Low

You can downloaded PBIX file from here.

 

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

This is definitely closer to the outcome I am trying to achieve but the logic is not quite right.

 

Rather than filtering the data for for only those that are high or low level, 

 

I want to include all of the distinct LinkIDs in the cohort (Q2 = 11) and if they have a 1 in RepeatLow = 1 and if they have a 0 in RepeatLow = 0.  There should always be 11 customers in the pie chart so for Q2 there should be 11 customers with 0.

 

I've created a table to show the data that I'm trying to put into the pie for both the RepeatLow and RepeatHigh options using Max. 

I'm wondering if need to create a summarize table but hoped there was a way to do it with filtering. 

Thank you so much for persisting with this!