How to get rid of total for measure

[Anonymous]

Hi, 

I've done some investigating on how to get rid of the total value for a table, using this measure: 

SupplierNameandNumberFiltered =

IF(

CALCULATE(COUNTROWS(IMSDocumentsHeadersSuppliers), FILTER(IMSDocumentsHeadersSuppliers, IMSDocumentsHeadersSuppliers[Supplier Number] = SELECTEDVALUE(Suppliers[Supplier Number]))) > 0,

("(" & SELECTEDVALUE(Suppliers[Supplier Name]) & " (" & SELECTEDVALUE(Suppliers[Supplier Number]) & " )" ), BLANK()

)

I've read that using HASONEVALUE can work but I cannot see where to place it - i've tried it in three places, and I keep getting errors. 

Any help with this would be great!

[v-yiruan-msft]

Hi @Anonymous ,

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.

Best Regards

Rena 

[Anonymous]

Hi @v-yiruan-msft

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 · Accepted solution]

@Anonymous 

Here is an example of ISINSCOPE in action:

[Anonymous]

@PaulDBrown Thank you that example is really clear 🙂 

[PaulDBrown]

@Anonymous 

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?

[Anonymous]

Hi @PaulDBrown 

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? 

[PaulDBrown]

@Anonymous
Can you please post your measure, the visual of the table and state the fields you are using in the table?

[Anonymous]

@PaulDBrown, I hope this helps 

Measure: 

SupplierNameandNumberFiltered =

IF(

CALCULATE(COUNTROWS(IMSDocumentsHeadersSuppliers), FILTER(IMSDocumentsHeadersSuppliers, IMSDocumentsHeadersSuppliers[Supplier Number] = SELECTEDVALUE(Suppliers[Supplier Number]))) > 0,

("(" & SELECTEDVALUE(Suppliers[Supplier Name]) & " (" & SELECTEDVALUE(Suppliers[Supplier Number]) & " )" ), BLANK())

Which provides the field Supplier for the table - It concatonates the supplier name and number in the table. I cannot provide a screen shot of the tablem here is an example version. I want to keep the totals on all the other columsn that I have totals on, but just remove them for example on the supplier column. This column uses this measure as it is a drill through page from a previous page that has an inactive relationship, I want to take the selected supplier number from the table Suppliers, and make that be teh same as the value from IMSDocumentHeadersSuppliers - which is where the rest of the data is coming from for the report below. 

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