Aggregating by ignoring specific fields in Table visual

[subhashg]

Input table

Output table Visual - While counting towns, measure(Count of Towns) should ignore "state" & count at Country level . So for India, Towns should result 2 for both rows instead of 1 inspite of having "state" feild in table visual.

Summarize(As shown above) is not working. Please help

[HotChilli · Accepted solution]

MeasureQ = CALCULATE(COUNT(theTable[t]), REMOVEFILTERS(theTable[s]))

t = towns, s = state