LINE CHART: Limitation on Alternative Measure

[Purushothaman]

Hi Experts,

I have line chart,  where I am Limiting Top 6  based on " Height of Line Measure: "ORG" but I need  Limit Top 6  based on Alternative Measure: "DUP'

Attached is the image for your reference.

Any Work arounds? Anyone, Please help!!

Thank you!!

[saranyadurai]

Hi @Purushothaman ,

Instead of using Limitation, you can try to write the Dimension like this,

aggr(if(Rank(count(DUP expression))<=6, Dimension), Dimension)

Limitation automatically pick the measure as you written Measures area.

Thanks,

Saranya

[Purushothaman]

Hi @saranyadurai ,

This expression is yielding me a proper results. I will message you the expression privately. If possible Please help me.

Thank you!