Forum Discussion
alisonpappas
Helper III
Helper IIICalculating 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...
amitchandak
Super User
Super Useralisonpappas , try one of the two
measure =
divide(calculate(Sum(Table[value]), filter(Table, Table[Column] ="A")),calculate(Sum(Table[value]), filter(Table, Table[Column] in{"A","B"})))
or
measure =
divide(calculate(Sum(Table[value]), filter(All(Table), Table[Column] ="A")),calculate(Sum(Table[value]), filter(All(Table), Table[Column] in{"A","B"})))