How to create measure referring to other measure

[Anonymous]

I'm having trouble using DAX to create a measure that refers to another measure.

The following are all in the same table:

XGeo_IN_Act is a custom column with the following formula:

XGeo_IN_Act = if('In Activations w/ Flag'[IN_Cross_Intra_Same] = "Same Country",0,if('In Activations w/ Flag'[IN_Cross_Intra_Same] = "Intra Geo", 0, 'In Activations w/ Flag'[Total_Activations]))

Total_Act_Unfilter is a measure with the following formula: 

Total_Act_Unfilter = CALCULATE(sum('In Activations w/ Flag'[Total_Activations]),ALL('In Activations w/ Flag'[IN_Cross_Intra_Same]))

*I have a visual which uses "IN_Cross_Intra_Same" as a filter, which "Total_Act_Unfilter" is meant to ignore. The "Total_Act_Unfilter" measure works on its own and will display data in my visual.

XGEO_perc is a measure with the following formula:

XGEO_perc = sum('In Activations w/ Flag'[XGeo_IN_Act])/sum('In Activations w/ Flag'[Total_Act_Unfilter])

See below sample data:

IN_Cross_Intra_Same	Total_Activations	XGEO_IN_Act
Intra Geo	9	0
Intra Geo	3	0
Intra Geo	2	0
Intra Geo	6	0
Intra Geo	7	0
Cross Geo	2	2
Cross Geo	8	8
Cross Geo	9	9
Cross Geo	9	9
Cross Geo	6	6
Same Country	1	0
Same Country	4	0
Same Country	0	0
Same Country	5	0
Same Country	2	0

Here, the measure Total_Act_Unfiltered equals 73 (sum of Total_Activations). The measure XGEO_perc would equal 47% (sum of XGEO_IN_Act divided by sum of Total_Activations).

When I try to create the XGEO_perc measure, I get the following error:

I then tried to correct this by using the following formula instead and got the same error.

Total_Act_Unfilter = CALCULATE(VAR Tot_Act_Unfilter = sum('In Activations w/ Flag'[Total_Activations]) return Tot_Act_Unfilter,ALL('In Activations w/ Flag'[IN_Cross_Intra_Same]))

[amitchandak · Accepted solution]

@Anonymous , Total_Act_Unfilter is measure, not need to sum again

divide( sum('In Activations w/ Flag'[XGeo_IN_Act]),[Total_Act_Unfilter])

[Anonymous]

Was banging my head on the wall with this, thanks a lot Amit.