I am trying to figure out how can i use
IF-THEN KEEP only ELSE DELETE other values for my calculation to display certain KPI's and not all.
I can use filter, But is it can be done using calculation ?
It depends on the context, but something like this would work without a filter:
SUM(IF [Category] = "Technology" then [Sales] END)
This would only sum sales for Technology category.
Retrieving data ...