Forum Discussion
Solved
Aggregating by ignoring specific fields in Table visual
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 inst...
- MeasureQ = CALCULATE(COUNT(theTable[t]), REMOVEFILTERS(theTable[s]))t = towns, s = state
MeasureQ = CALCULATE(COUNT(theTable[t]), REMOVEFILTERS(theTable[s]))
t = towns, s = state