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 instead of 1 inspite of having "state" feild in table visual.
Summarize(As shown above) is not working. Please help
- MeasureQ = CALCULATE(COUNT(theTable[t]), REMOVEFILTERS(theTable[s]))t = towns, s = state
1 Reply
- MeasureQ = CALCULATE(COUNT(theTable[t]), REMOVEFILTERS(theTable[s]))t = towns, s = state