Forum Discussion
Matrix row subtotal issue
Hi team, I have the below matrix that has measures for Sum Total Amount, Latest Transaction Date, and Latest Transaction Date Total Amount. In the maxtrix subtotal "C1", it returns a value o...
I have updated my post and added a simple pbix example, similar to my actual file.
lbendlin
Super User
Super User
Latest Transaction Date Total Amount =
var a = ADDCOLUMNS(summarize(Sheet1,[Supplier]),"ltd",CALCULATE(max(Sheet1[TransactionDate])))
var b = ADDCOLUMNS(a,"ltv",var s=[Supplier] var d=[ltd] return CALCULATE(sum(Sheet1[Amount]),Sheet1[Supplier]=s,Sheet1[TransactionDate]=d))
return sumx(b,[ltv])