Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

wrong subtotals in matrix visuals

Hi everyone,    I've got a problem with a matrix subtotals in the report. For # of transaction column calaculation getting wrong subtotals in matrix table...I used some calcualtion for get...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    5 years ago
    subtotal_transaction = if(HASONEVALUE('table'[Transaction type]),[# of transaction],SUMX(VALUES('table'[Transaction type]),[# of transaction]))
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , change return like give below, replace with correct un summarized columns in visual

sumx(summarize(Table, Table[MTD], Table[By transaction], "_1", if(isblank(_Count1), _Count2, _Count1)),[_1])