How to get distinct count even after having multiple dimensions

[loganathan]

Hi All,

i have data like,

day	month	alerts
1	May	A1
2	May	A2
3	May	A3
4	May	A1
5	May	A4

if i do 'Distinct count of alerts' in KPI i will get 4.

like same if i do 'Distinct count of alerts' in table where my dimensions are day and month i will get 5. which is valid.

but in table too i need it to be '4' as i dont want to count 'A1' again means my result table must  be like below. Any idea how to achieve this.

day	month	distinct count of alerts
1	May	1
2	May	1
3	May	1
4	May	0
5	May	1

[Chanty4u]

Try this 

Count({<alerts = {"=Count(distinct {<day, month> alerts) > 0"}>} alerts)

[loganathan]

Hi,

Thanks for your quick response. But this expression doesn't work. TIA

[BrunPierre]

Hi, Try this.

Count(DISTINCT If(Aggr (Count(DISTINCT alerts), month, day) = 1, alerts, Null()))

[loganathan]

Hi Brun Pierre,

Thanks for your help. but tried with this condition still it doesnt work. Please advise.

Thanks.,

[tresesco]

Note: Disable zero/null suppression

[BrunPierre]

Count(Aggr(Only(alerts), alerts))