Share per each dimension

[maxsheva]

Hi,

LOAD * INLINE [

Example, Date, Value1, Value2

Example1, 01/02/2017, 70, 70

Example1, 01/04/2017, 80, 80

Example1, 01/07/2017, 50, 30

Example1, 01/09/2017, 30, 50

Example2, 01/12/2017, 70, 70

Example2, 01/15/2017, 80, 80

];

I try to find share for each date in Example

Count(Distinct Date)/Aggr(Count( Distinct Date),Example)

It calculates only for one date value per dimension(Example)

I need share for each date.

Thx.

[sunny_talwar · Accepted solution]

Try this

Count(Distinct Date)/Aggr(NODISTINCT Count( Distinct Date),Example)

or this

Count(Distinct Date)/Count(Distinct TOTAL <Example> Date)

[maxsheva]

Thank you Sunny!