Forum Discussion
Solved
Ignoring some rows while aggregating + selection on field.
Hi Experts - Could you please assist me on below query? The channel field in the table has 4 rows (including Total) and it looks like as below: I would like to get assistance on how to exc...
How about:
Count = IF(ISFILTERED (Table[Channel]), SUM(Table[Count]), CALCULATE(SUM(Table[Count]), Table[Channel] = "Total")
How about:
Count = IF(ISFILTERED (Table[Channel]), SUM(Table[Count]), CALCULATE(SUM(Table[Count]), Table[Channel] = "Total")
It worked like a charm!! Many thanks Paul. Appreciate your swift response and assistance.