Forum Discussion
Sum by categories which are in the same column
Hi,I need to create measures that allows me to sum by categories...this is the escenario: Thanks in advance
Hi @vixicai...what about this?...
I like what you did but he needs something like this I guess:
A SUM Categories = CALCULATE(SUM(Table1[US DOLLARS]);Table2[Category]="A")
what do you think?
mkeisha
Helper I
Helper IHi do you already have a Sales table and a Categories table that have a relationship created? Can't tell from what you've provided.
Thanks.
there is only one table....I need to sum the USD considering "AA" category and ignoring the others categories in the column.
Ive seen it before...but I cant find the dax :(