EXpressions

[Richard84]

I have a bar chart and I want to get a percentage of numbers that are lower than say 1000gr and a percentage of numbers below 1500gr and so on... the X-axis(variable name: weight) displays 1000gr, 1500gr, 2000gr.......

this is what I have been messing with,

if([Weight]<=1000, count(Total [Fish weight]<0.999),[Fish weight])

[Or · Accepted solution]

Have a look at using the Class() function.

[Richard84]

Thank you it worked a treat.