Forum Discussion

Amerivike's avatar
Amerivike
Advocate II
6 years ago

Filtering Denominator Based on Data From Another Column

  I have a dataset that looks like this:   State Ship Date Account Category Product Ship Volume TX 1/4/2020 Account 1 Category A Product 6        5 TX 1/4/2020 Account 1 Cate...
Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

Amerivike - If I am following this correctly, maybe:

Denominator = 
  VAR __Rows = FILTER('Table',[Product] = "Product 6")
  VAR __Accounts = DISTINCT(SELECTCOLUMNS(__Table,"Account",[Account]))
  VAR __Table = FILTER('Table',[Account] IN __Accounts)
RETURN
  SUMX(__Table,[Ship Volumn])