Calculated measure issue

[devarasu07]

Hi,

I'm try to get below output using below expression  and got null value for one condition can you advise me

aggr(count([Opening SOH]),ArticleNo,Color)/aggr( count(total [Opening SOH]),ArticleNo,Color)

[sunny_talwar]

What is your dimension? It seems to be a calculated dimension and I am not sure what that is?

[sunny_talwar · Accepted solution]

Try this

Dimension

=Aggr(If(Count([Opening SOH])/Count(TOTAL [Opening SOH]) < 0.25, '< 4 Sizes', '>4 Sizes'), ArticleNo, Color)

Expression

Count([Opening SOH])/Count(TOTAL [Opening SOH])