Measure on Axis

[Anonymous]

Hello

I have some student data as follows  (Blue fields are measures)...

I want to plot the students by the Pass Range, but when I pull the Passed Range measure onto a chart, it doesn’t show the groupings (just the 25-49 % Range) and I don’t get the ‘Don’t Summarize’ option.

The Pass Range measure is …

Pass Range = IF( [pct Passed Exams] <= 0.24,

"0-24 % Range",IF([pct Passed Exams]> 0.24 && [pct Passed Exams] <= 0.49,

"25-49 % Range",IF([pct Passed Exams]> 0.49 && [pct Passed Exams]< 0.74,

"50-74 % Range","75-100 % Range")))

If I pull the Student_ID, I get the correct value per student, but I can't seem count students by Passed Range 

Any suggestions how I fet this to work?

Thanks in advance

[parry2k]

@Anonymousjust checking you are adding passed range as column in your model not measure

[Anonymous]

Thank for getting back to me

The passes range is a measure. In the table students can have multiple exams, so I count the number of exams and the number of exams passed, so It nees to be a measure and not a Calc Col?

regards/

[parry2k]

@Anonymous I had similar solution provided in another post, take a look and make the changes accordingly. 

[Anonymous · Accepted solution]

Thanks for pointing out the article.

It's not what I'm looking for, but I managed to solve the issue using Calc Cols.

Regards/

[parry2k]

@Anonymous glad to know it worked. May be you want to put your solution so that others can take benefit. Cheers!