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]))
Anonymous's avatar
Anonymous
Not applicable
5 years ago
subtotal_transaction = if(HASONEVALUE('table'[Transaction type]),[# of transaction],SUMX(VALUES('table'[Transaction type]),[# of transaction]))