Forum Discussion

alisonpappas's avatar
alisonpappas
Icon for Helper III rankHelper III
6 years ago

Calculating a % while excluding others in the same column

Hi All,   I need help with a DAX formula to do the percent of an item. I have a coulnm that consists of 5 different items, A B C D E, for example. I only want to use two in an equation: A/A+B. This...
Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

alisonpappas - Hard to be specific without sample data but maybe:

Measure =
  VAR __Numerator = SUMX(FILTER(ALL('Table'),[Column]="A"),[Value])
  VAR __Denominator = SUMX(FILTER(ALL('Table'),[Column]="A" || [Column]="B"),[Value])
RETURN
  DIVIDE(__Numerator,__Denominator,0)