Forum Discussion

ADSL's avatar
ADSL
Icon for Post Prodigy rankPost Prodigy
3 years ago
Solved

Variant 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

1 Reply

  • Hey ADSL ,

    it's just rounding your values.

    Try to change yout display unit in your visual settings.

    Best regards