User Profile
_iamsheinny
Frequent Visitor
Joined 3 years ago
User Widgets
Contributions
Re: Would like to ask regarding on POWER BI, I need to calculate only a distinct Order No
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.Would like to ask regarding on POWER BI, I need to calculate only a distinct Order No
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..
