Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I've done some investigating on how to get rid of the total value for a table, using this measure:
Solved! Go to Solution.
@Anonymous
Here is an example of ISINSCOPE in action:
Proud to be a Super User!
Paul on Linkedin.
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
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.
@Anonymous
Here is an example of ISINSCOPE in action:
Proud to be a Super User!
Paul on Linkedin.
@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?
Proud to be a Super User!
Paul on Linkedin.
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?
Proud to be a Super User!
Paul on Linkedin.
@PaulDBrown, I hope this helps
Measure:
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 |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |