Forum Discussion
Jagan_MFilterIT
Helper I
Helper IReturn Second highest value from a summarize Table
Hi, I have a requirement where I want values of products which had first and second highest reviews. For getting the product which has the highest number of reviews I am using the following Dax ...
Jagan_MFilterIT , Create measure like these
Measure = CALCULATE('4. Comments_Measures'[review count],filter('00. ITC_Comment','00. ITC_Comment'[comment_sentiment_value] ="Positive"))
Rank = rankx(allselected('00. ITC_Comment','00. ITC_Comment'[theme_1]), [measure],,desc,dense)
Rank 2= sumx(filter(values('00. ITC_Comment','00. ITC_Comment'[theme_1]), [Rank] =2), [Measure])
either you can filter Rank at visual or use a measure like Rank 2
Jagan_MFilterIT , Try like
Rank 2= maxx(filter(values('00. ITC_Comment','00. ITC_Comment'[theme_1]), [Rank] =2), [theme_1])
Jagan_MFilterITHelper I
Helper IThanks a lot Sir, This worked!