Would like to ask regarding on POWER BI, I need to calculate only a distinct Order No

[_iamsheinny]

I would like to count distinct of Order number but when visualize in the table, Order No. can be still found in two category instead it should only be included in one category..

On this table as you can see, it's okay on the total tally, but when breakdown to specific category it's not tally - it's over compared to total, since i believe some of the order no, where included on both category instead of only once..

[_iamsheinny]

actually there are no relationship established, since it's from one table only...

[_iamsheinny]

basically in power bi, i have an issue when i use category in matrix table....

[FreemanZ]

In your second table, what do you put to Values field?

Are all the mentioned columns (taker_name, On PT Flag, order_no, and dups)  from the same table?

[_iamsheinny]

actually this is the current situation.

I have an excel file to double check the data taht is in power bi..

in excel file, i have created a column to distinguish if each Order No. is distinct or Not.

in power bi, i just drag and drop the Order No. on the table and set it up in disticnt count.

[FreemanZ]

name-order is many-many relationship, order-flag is one-many relationship?