Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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.
Check out the November 2023 Power BI update to learn about new features.