Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
ADSL
Post Prodigy
Post Prodigy

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.

 

2023-10-02_21-14-05.png

 

Any suggestion/advise of this issue?

 

Thanks and Regards,

 

 

1 ACCEPTED SOLUTION
Timuran
Resolver I
Resolver I

Hey @ADSL ,

it's just rounding your values.

Try to change yout display unit in your visual settings.

Best regards

View solution in original post

1 REPLY 1
Timuran
Resolver I
Resolver I

Hey @ADSL ,

it's just rounding your values.

Try to change yout display unit in your visual settings.

Best regards

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors