Forum Discussion
Changing cards based on filter selected
Neutralcats , the above measurements should work at region and subregion with GT(Overall, no filter). But if you want to filter only the selected total you can use allselected
like
AverageLifeExpectCompare =
VAR averageLifeExpect =
CALCULATE( AVERAGE (Sheet1[Life Expectancy]),allselected(Sheet1[State]))
RETURN
IF (AVERAGE(Sheet1[Life Expectancy]) >= averageLifeExpect, "Above Average","Below Average")In case you want filter for Above and below avg, refer this video
Customer Retention with Dynamic Segmentation, New/Lost/Retain Customer Count: https://www.youtube.com/watch?v=W4EF1f_k6iY
Super UserNeutralcats , the above measurements should work at region and subregion with GT(Overall, no filter). But if you want to filter only the selected total you can use allselected
like
AverageLifeExpectCompare =
VAR averageLifeExpect =
CALCULATE( AVERAGE (Sheet1[Life Expectancy]),allselected(Sheet1[State]))
RETURN
IF (AVERAGE(Sheet1[Life Expectancy]) >= averageLifeExpect, "Above Average","Below Average")
In case you want filter for Above and below avg, refer this video
Customer Retention with Dynamic Segmentation, New/Lost/Retain Customer Count: https://www.youtube.com/watch?v=W4EF1f_k6iY
Thank you! Do you know what I would do to dynamically change the card name? I don't have a measure for it, only a field.
I did get this far -