I've done some investigating on how to get rid of the total value for a table, using this measure:
Solved! Go to Solution.
use ISINSCOPE, as in:
remove total = IF(ISINSCOPE(table[column]), [your meausre], BLANK())
where table[column] is the field in the Table/Matrix visual.
does that make sense?
Hi @annakentmuller ,
The total value is from the summary value of the table field? Or do you just want to remove summary section below the table visual as Table 2 in the below screenshot ? If it's the latter , you can go to " Format " tab in in-the-name and find " Total " option to to toggle it off .
If the above information is not in your scenario, please provide some sample data in related tables and your expected results. Thank you.
no sorry that doesn't seem to work.
I tried wrapping my existing measure - which is the column in the table and also I have tried creating a new measure doing this - which just creates an entirely blank column.
I want the total for thiscolumn to not exist on the table.
Any other ideas?
I just want the first columns total to be removed, not both. I am sorry I cannot provide data because our data is not anonymised yet. But basically, it looks similar to your first example, but I want to keep the 20 and get rid of the text part.
@PaulDBrown, I hope this helps
|Supplier (using my mesaure)||Transaction no.||Date||Base Invoice Value|
|Supplier 1||1||30 Aug 2013||10.00|
|Supplier 1||2||12 Dec 2019||20.00|
|Total: Supplier 1||30.00|
It’s time for another PBI Community recap!
Visit our Community Blog for articles, guides, and information created by fellow community members.
Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.
Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!