Hi, have problems that visualizations of card and table not showing the same results. I have a simple summary on a column of quantities, a measure and a slicer. the result should be 0 and table shows correct value but card shows strange numbers for 2 of the slicers values. I have checked that there is no junk in the data. How to handle this?
The card I believe is showing close to zero, it just doesn’t seem to be rounded.
Have you tried to place ROUND( … ) around the formula? See how you go with that.
My guess is there is probably a single erroneous value somewhere.
You could also round the column values as well and this should fix this as well I believe.
Thanks, ROUND solved the issue
//Lars