Looker Aggregation of Measures

[Madhura_0117]

I am trying to create a measure of type count_distinct and I want to use it in another measure using type sum. In short I am trying to sum the count_distinct measure.
For Example, 

My first measure is "ABC" (type: count_distinct) , second measure is "XYZ" (type: sum on measure ABC). Please see below example:

1. Measure ABC

measure: ABC{

type: count_distinct

sql: ${TABLE}.abc

}

2. Measure XYX

measure: XYZ{

type:sum

sql:ABC

}
I cannot perform this aggregation as it is throwing error. Could you please confirm whether the double aggregation (like example above) can be performed in looker?

[Mohammad_Ali]

Try this

Measure: xyz{

Type:number

Sql:Sum($ABC)