Forum Discussion
ADSL
Post Prodigy
3 years agoVariant between Total Distinct Count of visual Table & Stacked Bar Chart
Dear BI Community Team,
I have a sales order data and create a mesuare to count the number of store purchased. When I build the visual of table by suppliers, by sales rep. I am getting the same number.
Measure:
Store_Purchased = CALCULATE(DISTINCTCOUNT('Sales Order'[Customer Code]), 'Sales Order'[Price_IND] = "OPT1", 'Sales Order'[BT_IND] = "BT2")
But if I build it as Stacked bar chart, and compare with table by sales rep or supplier. It's different.
Any suggestion/advise of this issue?
Thanks and Regards,
Hey ADSL ,
it's just rounding your values.
Try to change yout display unit in your visual settings.
Best regards