Forum Discussion
messyjesse_
8 years agoFrequent Visitor
Retain average trend line despite slicer
Hello, In the screenshot below I have different cohort default rates charted over time. Each solid colored line represents a college. The black dashed line is the average of all colleges for that...
v-yuta-msft
Community Support
8 years agoHi messyjesse_,
Based on your description, you want to have an average value which meets the condition and don't be affected by the slicer, right?
I recommend you to use calculate column instead of measure to calculate average rate. In addtion, could you please provide your table structure and measure to achieve the avreage default rate?
Regards,
Jimmy Tao