how to total limited number of columns

[Anonymous]

instead of calculating total for all the columns. i need to total only limited columns

[dax · Accepted solution]

Hi Darmesh,

I am not clear  about your data structure, If your data structure is like  Matrix and want to  calculate specific columns, you could try to use filter in measure like below

measure= calculate(sum([value]), filter(table, [columnname]="a1"))+calculate(sum([column]), filter(table, [columnname]="a2"))

If your structure is like table, you could calculate column directly

measure1=sum([a1])+sum([a2])

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.