Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi all
I have a visual table being filtered by company from a slicer. The filter breaks when I add a measure in the visual table. Below are details of my issue:
Measure =
CALCULATE(SUM('Table_reports'[No. customers])+0,
Problem:
My visual table contains data from Table_reports. When I add the measure into the visual table it ignores the slicer, listing all companies instead of the selected company in the slicer.
Thank you for your help in advance.
Solved! Go to Solution.
@oj62012 It's likely the +0 causing the issue. What happens if you remove that?
@oj62012 It's likely the +0 causing the issue. What happens if you remove that?
Hey again,
Sorry, it actually worked! I'm not sure why it didn't worked the first time.
Thank you so much for your help!
Cheers
Hi Greg
Thanks for responding so quickly.
I removed the +0, I got the same results.
User | Count |
---|---|
21 | |
19 | |
12 | |
9 | |
8 |
User | Count |
---|---|
30 | |
27 | |
14 | |
13 | |
10 |