Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
10 | |
10 | |
9 | |
9 |
User | Count |
---|---|
20 | |
13 | |
12 | |
11 | |
8 |