Total in the Table visual

[vjnvinod]

Hi,

i have a table visual(see below), where i have 2 coloumn Gter and Margin, see below

what i want to do is show the total of GTER coloumn only, not margin total

how do i do that?

[mahoneypat]

You will need to add a condition to your margin measure to prevent a result in the "total" row.  You didn't show the column(s) in your table but you need something like this.

Account Margin % YTD = IF(HASONEVALUE(Table[Column]), [Account Margin % YTD])

This will return blank in the total row.  Replace Table[Column] with one of the columns in your table.  Also, you can reference your existing margin measure as shown, or just wrap your current expression with the IF(HASONEVALUE ....).

Regards,

Pat

[vjnvinod]

@mahoneypat  @amitchandak 

Note: Account Margin % YTD is a coloumn and not measure.

so the below formula you have provided doesn't works, i tried and its showing me everything blank

[vjnvinod · Accepted solution]

@mahoneypat @amitchandak 

please ignore, i figured it out, i just had to push the coloumn to "Dont summarize" and it resolved the issue