Forum Discussion
a simple filtered subtotal
Hi thank you in advance for you help. I try to simplify my issues... I'm in EXCEL, Power Pivot and I want to introduce a new calculated measure. myTable Code (key) Area valueA ...
Greg_Deckler
Community Champion
Community Championdanieleb75 Try:
Column =
VAR __ValueA = MAX([valueA])
VAR __Area = MAX([Area])
VAR __Total = SUMX(FILTER(ALL('Table'),[Area] = __Area),[valueA])
VAR __Result = DIVIDE(__ValueA, __Total)
RETURN
__Result
I don't work in Excel but rather Power BI Desktop so no idea if this works the same.
and than... why the use of "MAX" operator?