Forum Discussion
Impactful IndividualTotal in the Table visual
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?
please ignore, i figured it out, i just had to push the coloumn to "Dont summarize" and it resolved the issue
3 Replies
- mahoneypat
Microsoft Employee
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
vjnvinodNote: 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
please ignore, i figured it out, i just had to push the coloumn to "Dont summarize" and it resolved the issue
