Forum Discussion
SeungLee95
Microsoft Employee
Microsoft EmployeeApply SUM Total to a Conditionally Formatted Column
I have the following column in my table called SR that has the following values: Null / 1 As seen on the table below, within the Matrix it'll calculate the Subtotal for each row based on the wh...
- Test Sum =var s = SUMX(ADDCOLUMNS('Table',"s",if([APType]="Classic",0,VALUE([TEST]))),[s])RETURN if(s=0,"N/A",FORMAT(s,"#"))
SeungLee95Microsoft Employee
Microsoft Employeelbendlin - May I ask how/what you mean on how to achieve that?
I don't think there'd be any issue if the output format was changed if it was consistent (for every row/level that it's showing for)
lbendlin
Super User
Super User
Test Sum =
var s = SUMX(ADDCOLUMNS('Table',"s",if([APType]="Classic",0,VALUE([TEST]))),[s])
RETURN if(s=0,"N/A",FORMAT(s,"#"))