Forum Discussion
Creating dynamic sum subtotal in column function
Hello Power BI comunity, I'm struggling with creating a dynamic subtotal sum in a custom column. The basic request is to have a subtotal sum which changes when the user applies a filter or slice...
Seems like you want something like this measure:
Measure =
var __item = MAX([Items])
var __table = FILTER(ALL('Table'),[Items] = __item)
RETURN
SUMX(__table,[Sold])
Thanks for your answer
Me issue is though I want to build it into a custom column, since i want to divide every single row/value with the 'total sum'.