Forum Discussion

greenskmachine's avatar
greenskmachine
Frequent Visitor
1 year ago

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...
lbendlin's avatar
lbendlin
Super User
1 year ago

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

greenskmachine's avatar
greenskmachine
Frequent Visitor
1 year ago

I have updated my post and added a simple pbix example, similar to my actual file. 

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago

     

    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])