Forum Discussion
Helper IVhow do i remove a total from a Table ?
Hi
Please see below.
How do i remove the total from the column "1-sub job 0 name" in the below table?
The field value = text ... i don't know why it is creating a total for this column.
it is based on a measure
Sean-OReilly change your measure like this
1-sub job 0 name = IF ( HASONEVALUE ( YourTable[Job_Number] ), <measure expression> )I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
5 Replies
- parry2k
Super User
Sean-OReilly change your measure like this
1-sub job 0 name = IF ( HASONEVALUE ( YourTable[Job_Number] ), <measure expression> )I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
Sean-OReillyThanks Parry - you are legend 👍
Tahreem24Make sure that it is marked as "don't summarize". Perhaps some aggregation mistakenly got selected.
- Tahreem24
Thanks, Parry! I could not see the screenshot attached.
Try the below thread, I hope you would get some idea:
https://community.powerbi.com/t5/Desktop/Hide-Columun-Measure-Total/m-p/811234