cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

How to get rid of total for measure

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!
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User I
Super User I

Re: How to get rid of total for measure

@annakentmuller 

 

Here is an example of ISINSCOPE in action:

Setup.png

 





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






View solution in original post

8 REPLIES 8
Highlighted
Super User I
Super User I

Re: How to get rid of total for measure

@annakentmuller 

 

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?





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Highlighted
Microsoft
Microsoft

Re: How to get rid of total for measure

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 .get rid of total.JPG

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 

Highlighted
Frequent Visitor

Re: How to get rid of total for measure

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? 

Highlighted
Frequent Visitor

Re: How to get rid of total for measure

Hi @yingyinr


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. 

Highlighted
Super User I
Super User I

Re: How to get rid of total for measure

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




Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Highlighted
Frequent Visitor

Re: How to get rid of total for measure

@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. DateBase Invoice Value
Supplier 1130 Aug 201310.00
Supplier 1212 Dec 201920.00
Total: Supplier 1  30.00
Highlighted
Super User I
Super User I

Re: How to get rid of total for measure

@annakentmuller 

 

Here is an example of ISINSCOPE in action:

Setup.png

 





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






View solution in original post

Highlighted
Frequent Visitor

Re: How to get rid of total for measure

@PaulDBrown Thank you that example is really clear 🙂 

Helpful resources

Announcements
June 2020 Community Highlights

June 2020 Community Highlights

Featured community members, changes to the Community, and more! Read up on recent Power BI community news.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors